oracle071考试报名,【2019年8月版本】Oracle OCP认证 071考试原题-57

choose two

Examine the description of the BOOKS table:

Name Null? Type

-------------------------------------------------------------

TRANSACTION_ID       NOT NULL       VARCHAR2(6)

TRANSACTION_                                   DATE DATE

AMOUNT                                              NUMBER(10,2)

CUSTOMER_ID                                     VARCHAR2(6)

The table has 100 rows

Examine this sequence of statements issued in a new session:

INSERT INTO books VALUES ('ADV12','Adventures of Tom Sawyer',NULL,NULL);

SAVEPOINT a;

DELETE FROM books;

ROLLBACK TO SAVEPOINT a;

ROLLBACK;

Which two statements are true?

A) The first ROLLBACK command restores the 101 rows that were deleted and

commits the inserted row.

B) The first ROLLBACK command restores the 101 rows that were deleted

,leaving the inserted row still to be commited.

C) The second ROLLBACK command does nothing.

D) the second ROLLBACK undoes the insert.

E) The second ROLLBACK command replays the delete.

Answer：BD

(解析：这道题注意回滚的范围。)