【OCP-062】1Z0-062最新考试题库解析-第2次课

【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 NUMBER (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（自动段空间管理）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:Reference: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 to function normally.D. All the sessions are terminated and active transactions are rolled back.Correct Answer:CSection: (none)Explanation:In addition, the database services, instances, service handlers, andlistening endpoints that were dynamically registered with thelistener will be unregistered and subsequently registered again.但是没有说当前的会话不能执行操作QUESTION 19Which statement is true regarding the startup of a database instance?A. The instance does not start up normally and requires manual media recovery after a shutdownusing the abort option.B. Uncommitted transactions are rolled back during the startup of t he database instance after ashutdown using the immediate option.C. There is no difference in t he underlying mechanics of the startup whether the database is shutdown by using the immediate option or the abort option.D. Media recovery is required when t he database is shut down by using either the immediateoption or the abort option.E. Instance recovery is not required if the database instance was shut down by usingSHUTDOWN IMMEDIATE.Correct Answer: ESection: (none)ExplanationExplanation/Reference:QUESTION 20Examine the memory-related parameters set in t he SPFILE of an Oracle database:memory_max_target6Gmemory_target=5Gpga_aggregate_target=500Msga_max_size=0sga_target=0Which statement is true?A. Only SGA components are sized automatically-B. Memory is dynamically re-allocated between t he SGA and PGA as needed.C. The size of the PGA cannot grow automatically beyond 500 MB.D. The value of t he MEMORY_TARGET parameter cannot be changed dynamically.Correct Answer: CSection: (none)Explanation在Oracle 12c R1之前，没有选项可以用来限制和控制PGA的大小。虽然你设置某个大小为PGA_AGGREG ATE_TARGET 的初始参数，Oracle会根据工作负载和需求来动态地增大或减小PGA的大小。而在12c中，你可以通过开启自动PGA管理来对PGA设定硬性限制，这需要对PGA_AGGREGATE_LIMIT参数进行设置。因此，你现在可以通过设置新的参数来对PGA设定硬性限制以避免过度使用PGA。QUESTION 21Which two statements are true about extents?A. Blocks belonging to an extent can be spread across multiple data files.B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.C. The blocks of a newly allocated extent, although free, may have been used before.D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespaeewhen all the rows in a table are deleted.Correct Answer: BCSection: (none)Explanation( 解析：该题属于传统的体系架构范围的知识点)Explanation/Reference:QUESTION 22You execute the commands:SQL>CREATE USER sidneyIDENTIFIED BY out_standing1DEFAULT TABLESPACE usersQUOTA 10M ON users TEMPORARY TABLESPACE tempACCOUNT UNLOCK;SQL> GRANT CREATE SESSION TO Sidney;Which two statements are true?A. The create user command f