Question

Which of the following is true of the "DROP TABLE" statement in SQL?
a. Deletes the table structure only
b. Deletes the table structure along with the table data
c. Works whether or not referential integrity constraints would be violated
d. It's not a SQL statement

Answer 1

Answer:

B

Explanation:

imagine dropping a shopping bag full of goodies into a trashcan (the bag = the table).   You will lose it all.  Referential integrity prevents you from deleting if there is an issue (that's the point of it :)  ).  And it is an SQL statement, or the question wouldn't be asked.