Oracle
1Z0-071 · Question #416
1Z0-071 Question #416: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #416. The question stem and answer options stay visible for context.
Question
You own table DEPARTMENTS, referenced by views, indexes, and synonyms. Examine this command which executes successfully: DROP TABLE departments PURGE; Which three statements are true? (Choose three.)
Options
- AIt will remove the DEPARTMENTS table from the database.
- BIt will drop all indexes on the DEPARTMENTS table.
- CIt will remove all views that are based on the DEPARTMENTS table.
- DIt will remove all synonyms for the DEPARTMENTS table.
- ENeither can it be rolled back nor can the DEPARTMENTS table be recovered.
- FIt will delete all rows from the DEPARTMENTS table, but retain the empty table.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.