第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 答案不對。