Which three statements are true?
Name Null type
-----------------------------------------------------
TRANSACTION_ID NOT NULL VARCHAR2(6)
TRANSACTION_DAYE DATE
AMOUNT NUMBER(10,2)
CUSTOMER_ID VARCHAR2(6)
Now 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;
A.The second ROLLBACK command restores the row that was inserted B.The first ROLLBACK command leaves the inserted row locked C.The second ROLLBACK command restores the 100 rows that were in the table originally D.The second ROLLBACK command rolls back the ROLLBACK TO SAVEPOINT a command E.The first ROLLBACK command leaves the table's 100 original rows locked F.The first ROLLBACK command restores the 100 rows that were in the table originally正确答案CEF
