第93题-OCP认证062考试题库2019最新考题解析
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询2018年的时候,OCP 11g考试题库大更新,052 053出现了很多新题,
2019年,11g即将停考的前期,Oracle又出现了一次大变动,12c出现了很多新题,比如062 063题库大更新
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:http://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
-------------------------------------------------------
QUESTION 93
Which four actions are possible during an Online Data file Move operation?
A. Creating and dropping tables in t he data file being moved
B. Performing file shrink of t he data file being moved
C. Querying tables in t he data file being moved
D. Performing Block Media Recovery for a data block in t he data file being moved
E. Flashing back the database
F. Executing DML statements on objects stored in t he data file being moved
Correct Answer: CDEF
Section: (none)
Explanation: 实验中发现数据文件迁移过程中,查看 DBA_extents 数据字典发现分配 给该表的数据块没有发生变化,由此可以判断在迁移过程中并没有删除表后再重建; 把表 truncate 以后,移动数据文件,也不见数据文件缩小,而且语法中也没有 shrink 的关键字,所以 B 答案不对。