8.3 Data Definition Language and DML Cambridge iAS 9618

What is the main purpose of Data Definition Language (DDL)?

• To define and modify the structure of a database.

• To insert and delete data from tables.

• To perform mathematical operations on data.

• To execute procedural logic within a database.

Which of the following is NOT a DDL command?

• INSERT

• CREATE

• ALTER

• DROP

What is the primary purpose of Data Manipulation Language (DML)?

• To query and modify data in a database.

• To define database structure.

• To delete database tables permanently.

• To create user authentication rules.

Which SQL statement is used to create a new database?

• CREATE DATABASE mydb;

• NEW DATABASE mydb;

• ADD DATABASE mydb;

• MAKE DATABASE mydb;

Which command is used to create a new table in SQL?

• CREATE TABLE

• INSERT TABLE

• ADD TABLE

• MODIFY TABLE

Which data type is best suited for storing a value of either TRUE or FALSE?

• BOOLEAN

• VARCHAR

• INTEGER

• REAL

What does the ALTER TABLE statement do?

• Modifies the structure of an existing table.

• Deletes an existing table.

• Inserts a new row into a table.

• Selects specific records from a table.

How do you add a primary key to an existing table?

• ALTER TABLE mytable ADD PRIMARY KEY (id);

• ADD PRIMARY KEY mytable (id);

• CREATE PRIMARY KEY mytable (id);

• MODIFY TABLE mytable ADD PRIMARY KEY (id);

Which SQL statement is used to add a foreign key constraint?

• FOREIGN KEY (column) REFERENCES Table(Column)

• ADD FOREIGN KEY (column)

• MODIFY FOREIGN KEY (column)

• CREATE FOREIGN KEY (column)

Which SQL clause is used to filter records based on a specific condition?

• WHERE

• ORDER BY

• GROUP BY

• FROM