Class - 12 CBSE Computer Science — Assertion Reason Type Questions

Assertion. Both DELETE and DROP TABLE carry out the same thing — deletion in tables.

Reason. The DELETE command deletes the rows and DROP TABLE deletes the whole table.

DDL & DML

2 Likes

Answer

(d)

Assertion is false but Reason is true.

Explanation
The DELETE command removes rows from a table while leaving the table structure intact. It does not delete the entire table, instead, it removes specific rows within it. On the other hand, the DROP TABLE command in SQL deletes a table from the database, including its structure and all its data. So, while both commands involve deletion, they operate on different levels: the DELETE command removes rows, while the DROP TABLE command removes the entire table.

Answered By

2 Likes