Oracle
1Z0-071 · Question #315
Which three statements are true about Data Manipulation Language (DML)? (Choose three.)
The correct answer is A. UPDATE statements can have different subqueries to specify the values for each updated C. DELETE statements can remove multiple rows based on multiple conditions. E. INSERT INTO...SELECT...FROM statements automatically commit. See the full explanation below for the reasoning.
Question
Which three statements are true about Data Manipulation Language (DML)? (Choose three.)
Options
- AUPDATE statements can have different subqueries to specify the values for each updated
- BINSERT statements can insert NULLS explicitly into a column.
- CDELETE statements can remove multiple rows based on multiple conditions.
- DDML statements require a primary key be defined on a table.
- EINSERT INTO...SELECT...FROM statements automatically commit.
How the community answered
(43 responses)- A81% (35)
- B7% (3)
- D12% (5)
Community Discussion
No community discussion yet for this question.