You need to delete a database table.
Which data definition language (DDL) keyword should you use?
A.
ALTER
B.
DELETE
C.
DROP
D.
TRUNCATE
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
DDL — create, alter, drop, truncate, rename
C and D is both the correct answer
0
1
@Pawan Chhangani, D is incorrect. The question asks you about deleting an object.
0
1
If you want delete a database table, the correct answer is C
0
0
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
1
0
C
Truncate only deletes the data. Drop deletes the table.
1
0