You need to delete a database table.
Which data definition language (DDL) keyword should you use?
A.
ALTER
B.
DELETE
C.
DROP
D.
TRUNCATE
Which data definition language (DDL) keyword should you use?
You need to delete a database table.
Which data definition language (DDL) keyword should you use?
DDL — create, alter, drop, truncate, rename
C and D is both the correct answer
@Pawan Chhangani, D is incorrect. The question asks you about deleting an object.
right answer is c, trunate deallocate the data(empty for reuse) from table, so table is there but no data, as all data will be deleted, but in this question it is asking for deleting table, not just data
C
Truncate only deletes the data. Drop deletes the table.