Introduction to SQL Quiz

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

Which of the following is a popular Database Management Tool?

• Microsoft SQL Server

• Notepad

• Excel

What is the syntax to create a new database?

• CREATE DATABASE database_name;

• CREATE TABLE table_name;

• DROP DATABASE database_name;

What does the NOT NULL constraint do?

• Ensures a column cannot have a NULL value

• Allows NULL values

• Ensures all values are unique

What is the command to delete an existing table?

• DROP TABLE table_name;

• DELETE TABLE table_name;

• REMOVE TABLE table_name;

What is the command to add a new column to an existing table?

• ALTER TABLE table_name ADD column datatype;

• ADD COLUMN table_name;

• CREATE COLUMN table_name;

What is the command to modify a column's datatype?

• ALTER TABLE table_name ALTER COLUMN column datatype;

• MODIFY COLUMN table_name;

• CHANGE COLUMN table_name;

What is the command to ensure all values in a column are different?

• UNIQUE on CREATE TABLE

• NOT NULL on CREATE TABLE

• PRIMARY KEY on CREATE TABLE

What does UNIQUE on CREATE TABLE ensure?

• All values in a column are different upon creating a table

• All values in a column can be the same

• Values can be null

• Values can be duplicated

What does PRIMARY KEY on CREATE TABLE do?

• Uniquely identifies each row in a table

• Allows duplicate values in a column

• Sets a default value for a column

• Ensures all values are null