首页 > 其他 > 详细

OCP考试题库变了,052新考试题及答案整理-32

时间:2018-08-02 12:11:38      阅读:212      评论:0      收藏:0      [点我收藏+]
32、 Examine these commands and their output:

? SQL> SELECT * FROM emp;

? ENO ENAME

? ---- -----

? 100 Adam

? 101 Alan

? SQL> INSERT INTO emp VALUES(102,‘Ben");

? 1 row created.

? SQL> COMMIT;

? Commit completed.

? SQL> UPDATE emp SET ename=‘Bryan‘ WHERE eno=102;

? 1 row updated.

? A power failure occurs. The Instance Is restarted and this query Is executed.

? SQL> SELECT ename FROM emp;

? What Is the outcome?

A) Only Adam and Alan are displayed.

B) Only Adam, Alan, and Bryan are displayed.

C) Adam, Alan, Ben, and Bryan are displayed.

D) No rows are returned.

E) Only Adam, Alan, and Ben are displayed.

Answer:E

技术分享图片

OCP考试题库变了,052新考试题及答案整理-32

原文:http://blog.51cto.com/13854012/2153524

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!