Multiple choice technology programming languages

..... table will remove all the rows and data in a table but table structure is not removed whereas in ..... table the entire table is removed and moved to recycle bin.

  1. DROP, DELETE

  2. TRUNCATE, DROP

  3. DROP, TRUNCATE

  4. DELETE, DROP
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE removes all rows from a table while keeping the table structure. DROP completely removes the table including its structure, and some databases move it to a recycle bin. The question asks for 'remove rows but not structure' first, then 'entire table removed'.

Keep practicing — related questions