Oracle
1Z0-082 · Question #150
Examine this description of the books table containing 100 rows: Now examine this sequence of statements Issued In a new session; Examine this description of the books table containing 100 rows…
The correct answer is A. The second rollback command restores the row that was inserted. C. The second rollback command rolls back the rollback to savepoint a command. E. The first RollBack command restores the row that was inserted. See the full explanation below for the reasoning.
Manage Data Concurrency
Question
Examine this description of the books table containing 100 rows:
Now examine this sequence of statements Issued In a new session; Examine this description of the books table containing 100 rows:
Which three statements are true?
Exhibits
Options
- AThe second rollback command restores the row that was inserted.
- BThe first rollback command leaves the table's 100 original rows locked.
- CThe second rollback command rolls back the rollback to savepoint a command.
- DThe first rollback command leaves the inserted row locked.
- EThe first RollBack command restores the row that was inserted.
- FThe second rollback command restores the 100 rows that were in the table originally.
- GThe first rollback command restores the 100 rows that were in the table originally.
How the community answered
(38 responses)- A84% (32)
- B11% (4)
- D3% (1)
- G3% (1)
Topics
#ROLLBACK#SAVEPOINT#transaction control#row locking
Community Discussion
No community discussion yet for this question.