SQL Database Creation and Management Quiz

What is the primary purpose of the SQL CREATE TABLE statement?

• To define the structure of a new database table
• To delete existing database records
• To insert data into a table
• To modify existing table columns

What does the NOT NULL constraint indicate in a table definition?

• The field must have a unique value
• The field is optional
• The field cannot be left blank
• The field cannot contain zero

Which SQL statement is used to add a new column to an existing table?

• ADD COLUMN
• MODIFY TABLE
• ALTER TABLE
• INSERT COLUMN

In a relational database, what is the primary purpose of a FOREIGN KEY?

• To establish relationships between tables
• To validate user input
• To encrypt data
• To create a primary key

Which SQL statement is used to insert a new record into a table?

• ADD RECORD
• INSERT INTO
• CREATE ENTRY
• NEW RECORD

What is the purpose of the DELETE statement in SQL?

• To modify existing records
• To remove a specific record from a table
• To create a new table
• To add new columns

Which database normalization form eliminates partial dependencies between attributes?

• Third Normal Form (3NF)
• First Normal Form (1NF)
• Second Normal Form (2NF)
• Boyce-Codd Normal Form (BCNF)

In a complex database design, what is the primary purpose of a composite key?

• To link multiple tables together
• To uniquely identify a single record
• To create a primary key with multiple attributes
• To combine multiple columns as a unique identifier

Which SQL command is used to modify existing table structure?

• MODIFY
• UPDATE
• ALTER
• CHANGE

What is the main function of the SQL DROP TABLE statement?

• To remove a column from a table

• To delete a table and its structure from the database

• To remove all records from a table

• To clear constraints from a table