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…
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ROLLBACK#SAVEPOINT#transaction control#row locking

