Oracle
1Z0-071 · Question #245
1Z0-071 Question #245: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #245. The question stem and answer options stay visible for context.
Question
Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?
Options
- ADELTE and TRUNCATE statements can have a rollback done to restore data into a table.
- BDELETE and TRUNCATE statements remove all indexes for the tables on which they are
- CDELETE but not TRUNCATE statement can be used to remove data from selective columns and
- DDELETE but not TRUNCATE statement can be used to selectively remove rows from a 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.