Oracle
1Z0-071 · Question #60
Which two statements are true about Data Manipulation Language (DML) statements?
The correct answer is B. An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table. E. A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a. See the full explanation below for the reasoning.
Question
Which two statements are true about Data Manipulation Language (DML) statements?
Options
- AAH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.
- BAn UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.
- CA DELETE FROM ..... statement can remove rows based on only a single condition on a table.
- DAn INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a
- EA DELETE FROM..... statement can remove multiple rows based on multiple conditions on a
- FAn UPDATE...SET.... statement can modify multiple rows based on only a single condition on a
How the community answered
(32 responses)- A3% (1)
- B72% (23)
- C16% (5)
- D9% (3)
Community Discussion
No community discussion yet for this question.