【CUUG内部资料】OCP讨论群：1015267481【OCP-062】1Z0-062最新考试题库解析-第1次课序：OCP11g认证即将结束，12c已经越来越热，考试共分为3个科目：071、062、063，071的题库解析已经上传，这次整理的是062的考试题，虽然考题多变、不断的增加新题，但有了下面的这些考题，相信会对广大考生有帮助作用，顺利通过OCP考试。QUESTION 1Examine the parameters for your database instance:NAME TYPE VALUE- - -undo_management string AUTOundo_retention integer 1200undo_tablespace string UNDOTBS1You execute the following command:SQL ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?A. Undo data is written to flashback logs after 1200 seconds.B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lackof space in the undo tablespace.C. You can perform a Flashback Database operation only within t he duration of 1200 seconds.D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwritethe undo before that time has elapsed.Correct Answer: DSection: (none)Explanation 验证过QUESTION 2A user establishes a connection to a database instance by using an Oracle Net connection. Youwant to ensure the following:1. The user account must be locked after five unsuccessful login attempts.2. Data read per session must be limited for the user.3- The user cannot have more than three simultaneous sessions.4. The user must have a maximum of 10 minutes session idle time before being logged offautomatically.How would you accomplish this?A. by granting a secure application role to the userB. by implementing Database Resource ManagerC. by using Oracle Label Security optionsD. by assigning a profile to the userCorrect Answer: DSection: (none)Explanation 验证过QUESTION 3As a user of the ORCL database, you establish a database link to the remote HQ database suchthat all users in the ORCL database may access tables only from the SCOTT schema in the HQdatabase. SCOTTs password is TIGER. The service mane HQ is used to connect to the remoteHQ database.Which command would you execute to create the database link?A. CREATE DATABASE LINK HQ USING HQ;B. CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ SC. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING HQ;D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING HQ;Correct Answer: CSection: (none)Explanation 验证过QUESTION 4What happens if a maintenance window closes before a job that collects optimizer statisticscompletes?A. The job is terminated and the gathered statistics are not saved.B. The job is terminated but the gathered statistics are not published.C. The job continues to run until all statistics are gathered.D. The job is terminated and statistics for the remaining objects are collected the next time themaintenance window opens.Correct Answer: DSection: (none) Explanation在数据库一直打开的情况下，GATHER_STATS_JOB会伴随维护窗口一起被启动，默认情况下如果到维护窗口关闭该JOB仍未结束则将被终止(这取决于该JOB的属性stop_on_window_close)，剩下的有待收集信息的对象将在下一个维护窗口中得到处理；如果数据库一直处于关闭的状态，并在某维护窗口的时间范围内该DB被打开，那么相应的维护窗口会被立即激活(ACTIVE)，同时GATHER_STATS_JOB自动作业也会被启动，但该自动作业仅会在一个窗口中自动运行一次。QUESTION 5You plan to create a database by using the Database Configuration Assistant (DBCA), with t hefollowing specifications:Applications will connect to the database via a middle tier.l The number of concurrent user connections will be high.l The database will have mixed workload, with t he execution of complex BI queriesscheduled at night.Which DBCA option must you choose to create the database?A. a General Purpose database template with default memory allocationB. a Data Warehouse database template, with t he dedicated server mode option and AMMenabledC. a General Purpose database template, with t he shared server mode option and AutomaticMemory Management (AMM) enabledD. a default database configurationCorrect Answer: CSection: (none)ExplanationExplanation/Reference:QUESTION 6Which two statements are true about the logical storage structure of an Oracle database?A. An extent contains data blocks that are always physically contiguous on disk.B. An extent can span multiple segments,C. Each data block always corresponds to one operating system block.D. It is possible to have tablespaces of different block sizes.E. A data block is the smallest unit of I/O in data files.Correct Answer: DEQUESTION 7Which two statements correctly describe the relationship between data files and logicaldatabase structures?A. A segment cannot span data files.B. A data file can belong to only one tablespace.C. An extent cannot span data files.D. The size of an Oracle data block in a data file should be the same as the size of an OS block.Correct Answer: BCSection: (none)QUESTION 8Which statement is true about the Log Writer process?A. It writes when it receives a sig