Q29 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?
- (A). The second rollback command restores the row that was inserted.
- (B). The first rollback command leaves the table’s 100 original rows locked.
- (C). The second rollback command rolls back the rollback to savepoint a command.
- (D). The first rollback command leaves the inserted row locked.
- (E). The first RollBack command restores the row that was inserted.
- (F). The second rollback command restores the 100 rows that were in the table originally.
- (G). The first rollback command restores the 100 rows that were in the table originally.
Answer: A,C,E