【第32题】【063题库】2019年OCP12c认证1Z0-063考试题库大全
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP 12c考试考3科,分别是071、062、063,之前071和062都已经做过解析,这里开始063题库解析,希望对考063的同学有帮助,顺利通过063考试。
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
-------------------------------------------------------
32题、Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;
RECYCLE_NAME ORIGINAL_NAME TYPE
--------------------------------------------------------------------------------------------------------------
binsgk31sj/3akk5hg3j21kl5j3d==$0 EMPLOYEE
TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true?
A. It flashes back the employee table and all the constraints associated with the table.
B. It automatically flashes back all the indexes on the employes table.
C. It automatically flashes back any triggers defined on the table.
D. It flashes back only the structure of the table and not the data.
E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
Answer: B,D
(解析:闪回表以后,除了引用其他表的引用完整性约束之外,所有约束在表被闪回之后自动恢复,所以 A 答案是
错的;索引是自动闪回;触发器也会自动闪回,而且名字被改变为:BIN$3JNiRebHSD+sRbnNmf45dQ==$0,跟索
引的处理方式一样;闪回表时结构和数据都会恢复回来。)