DROP TABLE CRICKET what does it mean?

Question

Evaluate DROP TABLE CRICKET .which one is true about this ?

a) all pending transactions are committed.
b) all views based on cricket table are deleted.
c) all data in the data table is deleted, but structure of the table is retained.
d) all synonyms based on the cricket table is deleted.

Answer 1

b) all views based on cricket table are deleted.

When we execute the DROP TABLE CRICKET then all the contents of the table is deleted, all the dependency of the content is deleted (cascade effect) and table structure is deleted.

Answer 2

Hello,
b) all view based on cricket table are deleted.

Table or Database deletion using DROP statement cannot be rolled back, so it must be used wisely.