OCP最新考试题库解析之052考试原题-12-20180824
,052 题库解析,CUUG真诚奉献 052-题库解析-12-20180824,题库新特点:, 最新052题库,按知识点分门别类,方便大家学习每周五晚8点-直播地址:ke.qq.com/course/326223 ocp考试讨论群:836361015 验证:ocp CUUG整理,官网:www.cuug.com,五.Alert log,94. Which two types of information can be found in the alert log? A) a record of all actions performed by SYS and SYSTEM. B) critical errors encountered by background processes. C) a record of all DDL statements performed by non-DBA users. D) instance recovery details,E) values of all initialization parameters whenever an instance is restarted. Answer:BD(验证过),95. You executed these commands: SQL> SHOW PARAMETER BACKGROUND_DUMP_DEST,NAME,TYPE VALUE,- background_dump_dest string /u01/app/oracle/diag/rdbms/orcl/orcl/trace,SQL> SHOW PARAMETER DIAGNOSTIC_DEST,NAME,TYPE VALUE,- diagnostic_dest string /u01/app/oracle,in which two locations and in which format is the alert log stored?,A) as a text le in /u01/app/oracle/diag/rdbms/orcl/orcl/alert. B) as a text le in /u01/app/oracle. C) as an HTML le in /u01/app/oracle.,D) as an XML le in /u01/app/oracle,E) as an HTML le in /u01/app/oracle/diag/rdbms/orcl/orcl/alert F) as an XML le in /u01/app/oracle/diag/rdbms/orcl/orcl/alert Answer:AF,十六.Fast_start_mttr_target,96. Which two are true about FAST_START_MTTR_TARGET? A) A higher value increases the I/O overhead.,B) It is overridden by LOG_CHECKPOINT_INTERVAL. C) It is applicable only when the database is in ARCHIVELOG mode. D) A lower value increase the time taken to perform instance recovery. E) If it is set to 0, the MTTR Advisor is disabled. Answer:BE,七.Install,97. You plan to install Oracle Grid Infrastructure and Oracle Database. Which two mandatory tasks must be completed before you perform these installations?,A) setting the ORACLE_SID environment variable. B) setting the ORACLE_BASE environment variable to an existing directory. C) creating the Oracle Inventory and OSDBA groups in the operating system. D) creating the oper and asmdba operating system groups. E) creating an operating system user to be the owner of Oracle installation.,Answer:CE,98. You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select the “Install and Congure Grid Infrastructure for a Standalone Server” option.,Which task is performed by OUI as part of this installation?,A) creation and conguration of Enterprise Manager Cloud Control on the server. B) creation of a general purpose database. C) creation of an ASM disk group and registration of ASM components with,Oracle Restart.,D) creation of privileged operating system groups that are used for OS authentication. Answer:C,99. You want to install Oracle 11g database software and create a database on ASM immediately after the install. You plan is to install both Oracle database and Grid Infrastructure. Which two are true in this scenario?,A) Both products must be of the same version. B) Both procucts must be installed by the same OS user. C) Each product must be installed in a different ORACLE_HOME. D) Grid Infrastructure must be installed rst E) Both products must be installed by using the same ORACLE_BASE. F) Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups.,Answer:CD,100. You are planning a softwore installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at least one database for each release managed by Grid Infrastructure for a Standalone Server. Which three are true in this scenario? A) Both Oracle versions and Infrastructure can be owned by the same O/S account. B) Oracle 11g Release 1 databases must be managed by Grid infrastructure 11 g Release1. C) Both Oracle versions and Infrastructure can be installed under the same ORACLE_BASE. D) Both databases can be managed by Grid Infrastructure 11g Release 2. E) Grid Infrastructure must be installed before both Oracle Database versions. F) Each version of database may be managed by a separate version of Grid Infrastructure.,Answer:CEF,101. Which task would you perform before running the Oracle Universal Installer (OUI) in silent or suppressed mode ?,A) Install the dbhome script. B) Install the coraenv script. C) Create the oraInst.loc le. D) Create the tnsnames.ora le. E) Create the oratab le. F) Install the oraenv script. Answer:C,十八.Server-generated,102. Which two are true about server-generated alerts ? A) They can be based only on database metrics. B) They can ben based only on instance metrics. C) They are visible in Oracle Enterprise Manger by default. D) All stateful alerts can be found in DBA_ALERT_HISTORY. E) Stateless alerts cannot be found in DBA_OUTSTANDING_ALERTS. F) Stateful alerts must always be cleard manually. Answer: CE (验证过),104. Which four are true about server-generated alerts? A) By default, a server-generated alert is raised for each tablespace that has 85% or more of its space used. B) Server generated alerts for tablespace space usage occur only if the tablespace can no longer be automatically extended. C) By default, a server-generated alert is raised for each tablespace that has 97% or more of its space used. D) Stateless alerts can be seen by querying DBA_OUTSTANDING_ALERTS. E) Stateful alerts that have not been cleared can be seen by querying DBA_ALERT_HISTORY. F) Stateful alerts that have been cleared can be seen by querying DBA_ALERT_HISTORY.,