Oracle
1Z0-007 · Question #101
1Z0-007 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Question
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)
Options
- AIt releases the storage space used by the table.
- BIt does not release the storage space used by the table.
- CYou can roll back the deletion of rows after the statement executes.
- DYou can NOT roll back the deletion of rows after the statement executes.
- EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will
- FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.