SQL DELETE Command MCQ DELETE Statement Practice Questions

Direction: Choose the correct option

Which SQL statement removes records from a table?

A. DROP

B. DELETE

C. REMOVE

D. ERASE

Direction: Choose the correct option

DELETE FROM students WHERE age < 18;

What will this query do?

A. Delete students under 18

B. Delete all students

C. Delete age column

D. Delete students table

Direction: Choose the correct option

What happens if you run DELETE without WHERE clause?

A. Deletes table structure

B. Deletes all rows

C. Deletes first row

D. Error occurs

Direction: Choose the correct option

What's the difference between DELETE and TRUNCATE?

A. DELETE can be rolled back, TRUNCATE cannot

B. Both are same

C. TRUNCATE can use WHERE

D. DELETE is faster

Direction: Choose the correct option

DELETE FROM orders WHERE order_date < '2020-01-01';

What does this query delete?

A. Orders before 2020

B. Orders on 2020-01-01

C. Orders after 2020

D. Orders table

Quipoin Menu