Oracle
1Z0-071 · Question #258
Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
The correct answer is A. DELETE can be used to remove rows from only one table in one statement. E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
Options
- ADELETE can be used to remove rows from only one table in one statement.
- BDELETE can be used to remove rows from multiple tables in one statement.
- CDELETE can be used to remove rows only for tables that are parents for a child table that has a
- DDELETE can be used to remove data from specific columns as well as complete rows.
- EDELETE and TRUNCATE can be used for tables that are parents for a child table that has a
How the community answered
(26 responses)- A81% (21)
- B12% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.