Question

Which of the following keywords is used to remove a database table in Oracle? (Points : 2) DROP TABLE

ALTER TABLE...DROP
DELETE TABLE
TRUNCATE TABLE

Answer 1

DROP TABLE

Step-by-step explanation:

DROP TABLE is used to remove a database table in Oracle.

The syntax is DROP TABLE <TableName>;

For example: Suppose there is a table called Student in the database which needs to be removed. Then the administrator with the required privilege can issue with the following command:

DROP TABLE Student;

This is distinct from DELETE statement which is used to delete individual row or set of rows.