Exam 1z0-071 Topic 16 Question 318 Discussion
Actual exam question for Oracle's 1z0-071 exam
Question #: 318
Topic #: 16
Question #: 318
Topic #: 16
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?

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?
Suggested Answer: B,D Vote an answer
by Marvin at Sep 26, 2026, 08:08 AM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).