Oracle
1Z0-071 · Question #245
Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?
The correct answer is D. DELETE but not TRUNCATE statement can be used to selectively remove rows from a table. See the full explanation below for the reasoning.
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.
How the community answered
(44 responses)- A16% (7)
- B7% (3)
- C5% (2)
- D73% (32)
Community Discussion
No community discussion yet for this question.