Data Manipulation Language (DML)

Question 1

What happens to omitted columns when using specific column syntax like `INSERT INTO Employees (EmpID, FirstName) VALUES (1, 'John');`?

A.

A) They are set to zero

B.

B) They receive NULL values

Explanation: Omitted columns default to NULL unless specified otherwise

C.

C) The statement fails

D.

D) They use default table values

Question 2

What is the primary purpose of the WHERE clause in an UPDATE statement?**

A.

A) To identify which rows should be updated based on specific conditions

**Explanation:** The WHERE clause is essential for targeting specific rows in an UPDATE operation. Without it, the statement would modify all rows in the table, risking unintended data loss.

B.

B) To specify which columns should be modified

C.

C) To define the new values being assigned to columns

D.

D) To create a backup of the data before modification

Question 3

What is the primary purpose of the **DELETE** statement in SQL?

A.

A) To create a new table

B.

B) To remove specific rows from a table based on a condition

**Explanation:** **DELETE** is a DML command used for selective row removal from a table using a **WHERE** condition.

C.

C) To modify column values in existing rows

D.

D) To add new rows to a table

📝 Data Manipulation Language (DML)

Quiz Complete!