Q138 Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK;
Which two statements are true? (Choose two.)
- (A). The second ROLLBACK command does nothing
- (B). The second ROLLBACK command replays the delete
- (C). The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- (D). The second ROLLBACK command undoes the insert
- (E). The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
Xem thêm:
- Q85 Which two statements are true about the Oracle join and ANSI join syntax?
- Q21. Which three are true about block media recovery?
- Insert 1 triệu bản ghi vào database tự động trong Oracle
- Lợi Ích và Thách Thức Của Việc Chấp Nhận Bitcoin Trong Thanh Toán
- Q78. How do you configure a CDB for local undo mode?