Which of the following keywords is used to remove a database table in Oracle 12c?
A) DROP TABLE
B) ALTER TABLE...DROP
C) DELETE TABLE
D) TRUNCATE TABLE

Question

Which of the following keywords is used to remove a database table in Oracle 12c?​
A) ​DROP TABLE
B) ​ALTER TABLE...DROP
C) ​DELETE TABLE
D) ​TRUNCATE TABLE

Quizplus · Accepted Answer

The keyword used to remove a database table in Oracle 12c is DROP TABLE. ALTER TABLE...DROP can be used to drop a column from a table, DELETE TABLE is not a valid keyword and TRUNCATE TABLE removes all the data from the table but keeps the table structure intact.

Which of the Following Keywords Is Used to Remove a Database