Oracle Database SQL — Question 15

Examine this command:

TRUNCATE TABLE test;

Table truncated.

Which two are true? (Choose two.)

Answer options

• A. The structure of the TEST table is removed.
• B. All the indexes on the TEST table are dropped.
• C. All the constraints on the TEST table are dropped.
• D. Removed rows can not be recovered using the ROLLBACK command.
• E. All the rows in the TEST table are removed.

Correct answer: D, E

Explanation

Option D is correct because once the TRUNCATE command is executed, the removed rows cannot be reinstated using ROLLBACK, as TRUNCATE is a DDL command. Option E is also correct because TRUNCATE removes all records in the TEST table without logging individual row deletions, effectively clearing the table.