【OCP-062】1Z0-062最新考试题库解析-第2次课
9页1、【CUUG内部资料】OCP讨论群:1015267481【OCP-062】1Z0-062最新考试题库解析-第1次课序:OCP11g认证即将结束,12c已经越来越热,考试共分为3个科目:071、062、063,071的题库解析已经上传,这次整理的是062的考试题,虽然考题多变、不断的增加新题,但有了下面的这些考题,相信会对广大考生有帮助作用,顺利通过OCP考试。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 N
2、UMBER (10, 2)AMOUNT 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(自动段
3、空间管理)2、在收缩表上必须启用 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:R
4、eference:QUESTION 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
《【OCP-062】1Z0-062最新考试题库解析-第2次课》由会员j***分享,可在线阅读,更多相关《【OCP-062】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页