Home » MCQs » Oracle MCQs » Oracle Subqueries, TRUNCATE TABLE, and WHERE Clause MCQs

To delete all records from a table, use the ____ statement in Oracle

3. To delete all records from a table, use the ____ statement in Oracle.

1. Remove
2. Truncate
3. Drop
4. None

Answer: B) Truncate

Explanation:

To delete all records from a table, use the truncate statement in Oracle.