Multiple choice technology databases

Table (having constraint) can only be delete by

  1. TRUNCATE

  2. DELETE

  3. DROP

  4. REMOVE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DROP is the correct command to completely remove a table with all its constraints; TRUNCATE fails with foreign key constraints, DELETE only removes rows, and REMOVE is not a valid SQL command.

Keep practicing — related questions