Computer Science
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
3 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
3 Likes
Related Questions
Assertion. There is no restriction on the number of columns that can have PRIMARY KEY constraint or UNIQUE constraints.
Reason. There can be multiple columns with UNIQUE constraint but PRIMARY KEY constraint can be defined only once for one or more columns.
Assertion. There are different commands for creating and changing table design.
Reason. The CREATE TABLE command creates the tables while ALTER TABLE command changes the design of an existing table.
Assertion. Both UPDATE and ALTER TABLE commands are similar.
Reason. The UPDATE command as well ALTER TABLE command make changes in the table.
What are different divisions of SQL and commands ? Give examples of commands in each division.