【CUUG内部资料】OCP-12C-1Z0-062题库解析-第2次课
9页1、【CUUG内部资料】OCP讨论群:1015267481【CUUG内部资料】OCP-12C-1Z0-062题库解析-第1次课序:2018年的时候,OCP 11g 考试题库大更新,052 053出现了很多新题,2019年,11g 即将停考的前期,Oracle 又出现了一次大变动,12c 出现了很多新题,比如 062 063 题库大更新QUESTION 16Examine the structure of the sales table, which is stored in a locally managed tablespace withAutomatic Segment Space Management (ASSM) enabled.Name Null? Type- - -PROD_ID NOT NULL NUMBERCUST_ID NOT NULL NUMBERTIME_ID NOT NULL DATECHANNEL_ID NOT NULL NUMBERPROMO_ID NOT NULL NUMBERQUANT I TY_S OL D NOT NULL NUMBER (10, 2)A
2、MOUNT SOLD NOT NULL NUMBER (10, 2)You want to perform online segment shrink to reclaim fragmented free space below the high water mark.A. Row movement is enabled.B. Referential integrity constraints for t he table are disabled.C. No queries are running on this table.D. Extra disk space equivalent to the size of t he segment is available in t hetablespace.E. No pending transaction exists on t he table.Correct Answer: ASection: (none)Explanation 使用 shrink 的前提条件:1)表所在的表空间必须使用 ASSM(自动段空间管理)2、在收缩表上必须
3、启用 row movement 选项QUESTION 17Which task would you recommend before using the Database Upgrade Assistant (DBUA) toupgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?A. shutting down t he database instance that is being upgradedB. executing the catctl.pl script to run t he upgrade processes in parallelC. running the Pre-Upgrade Information ToolD. copying the listener.ora file to the new ORACLE_HOMECorrect Answer: CSection: (none)ExplanationExplanation/Reference:Reference:QUEST
4、ION 18Your database is open and the listener LISTNENER is up. You issue the command:LSNRCTL RELOADWhat is the effect of reload on sessions that were originally established by listener?A. Only sessions based on static listener registrations are disconnected.B. Existing connections are not disconnected; however, they cannot perform anyoperations until the listener completes the re-registration of the database instanceand service handlers.C. The sessions are not affected and continue to function no
《【CUUG内部资料】OCP-12C-1Z0-062题库解析-第2次课》由会员j***分享,可在线阅读,更多相关《【CUUG内部资料】OCP-12C-1Z0-062题库解析-第2次课》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页