《OCP考试052最新考试题库原题-12-20180824》由会员分享，可在线阅读，更多相关《OCP考试052最新考试题库原题-12-20180824（21页珍藏版）》请在金锄头文库上搜索。
1、052 题 库解析CUUG 真诚奉献052-题库解析-12-20180824题库新特点： 最新 052 题库，按知识点分门别类，方便大家学习每周五晚 8 点-直播地址： 考试讨论群：836361015 验证：ocpCUUG 整理，官网：五.Alert log94. 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 proc
2、esses. 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_des
3、t string /u01/app/oracle/diag/rdbms/orcl/orcl/traceSQL SHOW PARAMETER DIAGNOSTIC_DEST NAME TYPE VALUE - diagnostic_dest string /u01/app/oraclein which two locations and in which format is the alert log stored?A) as a text file in /u01/app/oracle/diag/rdbms/orcl/orcl/alert.B) as a text file in /u01/a
4、pp/oracle.C) as an HTML file in /u01/app/oracle. D) as an XML file in /u01/app/oracleE) as an HTML file in /u01/app/oracle/diag/rdbms/orcl/orcl/alertF) as an XML file in /u01/app/oracle/diag/rdbms/orcl/orcl/alert Answer：AF十六.Fast_start_mttr_target96. Which two are true about FAST_START_MTTR_TARGET?A
5、) 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
6、 97. You plan to install Oracle Grid Infrastructure and Oracle Database.Which two mandatory tasks must be completed before you perform theseinstallations? A) setting the ORACLE_SID environment variable. B) setting the ORACLE_BASE environment variable to an existing directory. C) creating the Oracle
7、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：CE98. You are installing Oracle Grid Infrastructure by using the Oracle UniversalInstaller (OUI). You selec
8、t the “Install and Configure Grid Infrastructure for a Standalone Server” option. Which task is performed by OUI as part of this installation?A) creation and configuration of Enterprise Manager Cloud Control on the server. B) creation of a general purpose database. C) creation of an ASM disk group a
9、nd registration of ASM components with Oracle Restart. D) creation of privileged operating system groups that are used for OS authentication. Answer：C99. 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 da
10、tabase 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 first E) Both products must
11、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：CD100. 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 releas
12、e 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/Saccount. B) Oracle 11g Release 1 databases must be managed by Grid infrastructure 11 g Release1. C) Both Oracle versions and Infrast
13、ructure 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：C
14、EF101. 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 file.D) Create the tnsnames.ora file.E) Create the oratab file. F) Install the oraenv script. An
15、swer：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) St
16、ateless 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 au
