Oracle
1Z0-882 · Question #31
Given the data from table t1: This DELETE command is executed: DELETE FROM t1 ORDER BY b.a DESC LIMIT 2; Which set of rows will be deleted by the command?
The correct answer is A. (7,1) and (1,4). See the full explanation below for the reasoning.
Question
Given the data from table t1:
This DELETE command is executed:
DELETE FROM t1 ORDER BY b.a DESC LIMIT 2; Which set of rows will be deleted by the command?
Options
- A(7,1) and (1,4)
- B(2,8) and (1,4)
- C(7,1) and (10,8)
- D(2,8) and (10,8)
How the community answered
(24 responses)- A71% (17)
- B17% (4)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.