071考試是OCP認證的一個重要科目，不少考生都在這里受傷，對此我們專門收集整理了近期071考試的原題，并對071題庫進行了講解，希望幫助大家順利通過071考試。
--------------------------------------------
071考試原題分享-第70題、choose the best answer:
View the Exhibit and examine the structure of the Book table.
The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:
SQL>INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer',null,null);
1 row created.
SQL>SAVEPOINT A;
Savepoint created.
SQL>DELETE FROM books;
101 rows deleted.
SQL>ROLLBACK TO SAVEPOINT A;
Rollback complete.
SQL>ROLLBACK;
Rollback complete.
Which statement is true?
A) The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.
B) Both ROLLBACK commands restore the 101 rows that were deleted.
C) The first rollback restores the 101 rows that were deleted and the second rollback causes the row that was inserted to be deleted and commits the changes.
D) Both ROLLBACK commands restore the 100 rows that were deleted.
Answer：C
(解析：答案很簡單，考的是回滾操作)
-----------------------------------------------
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：https://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與
