Oracle
1Z0-007 · Question #50
1Z0-007 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)
Options
- AYou cannot roll back this statement.
- BAll pending transactions are committed.
- CAll views based on the DEPT table are deleted.
- DAll indexes based on the DEPT table are dropped.
- EAll data in the table is deleted, and the table structure is also deleted.
- FAll data in the table is deleted, but the structure of the table is retained.
- GAll synonyms based on the DEPT table are deleted.
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.