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:
- Những Ứng Dụng Thú Vị Xây Dựng Trên Mạng Blockchain Của Bitcoin
- Đạo đức AI: Những thách thức và tranh cãi xung quanh công nghệ này
- Rman là gì?
- Sử dụng Database Link trong Oracle Database
- Q7. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?