【OCP题库-12c】最新CUUG OCP 071考试题库(70题)

发布时间:2020-04-08 17:28:10 作者:cto_5359
来源:网络 阅读:347

70、(31-2)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

(解析:答案很简单,考的是回滚操作)

推荐阅读:
  1. OCP考试的那段难忘的经历
  2. 【OCP 12c】最新CUUG OCP-071考试题库(62题)

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

ocp cuug 12c

上一篇:svn无法cleanup常见解决方案

下一篇:cdn加速与不加速的区别在哪里

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》