《CUUG内部OCP题库解析-052-文档2》由会员分享,可在线阅读,更多相关《CUUG内部OCP题库解析-052-文档2(16页珍藏版)》请在金锄头文库上搜索。
1、CUUG内部OCP题库解析-052-文档8题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。下面的题是(052考试-第2个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/191、.Which two are true about the Archive (ARCn) processes? A) They automatically delete obsolete archive logs to m
2、ake space for new archive logs. B) They are used during Instance recovery. C) They archive redo directly from the redo log buffer. D) They are enabled only when the database Is In ARCHTVELOCmode. E) They create archivelogs after every log switch. Answer:DEAdministrator CUUG内部OCP题库解析-052-文档2 7/17/192
3、、Which two are true about Optimizer Statistics? A) They do not persist across Instance restarts. B) They are automatically updated when DDL statements execute. C) They are gathered by the Manageability Monitor (MMON) background process. D) They can be gathered by executing the PL/SQL procedures in t
4、he DBMS_STATS package. E) They can be used to determine the events on which a database instance waited. F) They provide Information to the Optimizer so that it can determine optimal execution plans for SQL statements. Answer:DFAdministrator CUUG内部OCP题库解析-052-文档2 7/17/193、Which structure can span mul
5、tiple data files? A) a permanent tablespace B) a bigfile tablespace C) a temporary tablespace D) a segment E) an extent Answer:ACDAdministrator CUUG内部OCP题库解析-052-文档2 7/17/194、For which requirement should you configure shared servers? A) accommodating an increasing number of users who runshort-durati
6、on, infrequent queries in an OLTP environment withlimited memory B) accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory C) submitting backup jobs at regular, 24-hour Intervals in an OLTP environment with limited memory D) performing bulk-lo
7、ad operations in a DSS environment with limited memory E) using Recovery Manager (RMAN) to recover a database Answer:AAdministrator CUUG内部OCP题库解析-052-文档2 7/17/195、Which two affect the time taken for instance recovery? A) size of redo logs B) size of UNDO tablespace C) FAST_START_MTTR_TARGET value D)
8、 size of archivelogs E) size of existing RMAN backupsets F) UNDO_RETENTION value Answer:ACAdministrator CUUG内部OCP题库解析-052-文档2 7/17/196、Yo u are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).Yo u select the Install and Configure Grid Infrastructure for aStandalon
9、e 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 privileged operating system groups that are used for OS authentication C) creation of a general purpose database D) creation of
10、an ASM disk group and registration of ASM components with Oracle Restart Answer:DAdministrator CUUG内部OCP题库解析-052-文档2 7/17/197、Which is true about external tables? A) The ORACLE_DATAPUMP access driver can be used to write data to external tables. B) Segments are allocated for external tables. C) They
11、 do not support partitioning. D) They may have Indexes. E) DML operations may be performed on external tables. Answer:CAdministrator CUUG内部OCP题库解析-052-文档2 7/17/198、Which two are true about the Fast Recovery Area (FRA)? A) It should be larger than the database. B) Space management In the FRA Is Influ
12、enced by the database backup retention policy. C) A database must be in ARCHIVELOG mode to use the FRA. D) It must reside on the same file system as the database data files. E) Only consistent backups can be stored in the FRA. Answer:ABAdministrator CUUG内部OCP题库解析-052-文档2 7/17/199、Which is true about
13、 the Automatic Diagnostic Repository (ADR)? A) It includes diagnostic data for critical errors for each server and background process. B) Its location is always set by the ORACLE_BASE variable. C) It is used only if the DIAGNOSTIC_DEST parameter ismanually configured. D) It only contains the alert l
14、og and trace files for background processes. Answer:AAdministrator CUUG内部OCP题库解析-052-文档2 7/17/1910、Which two are true about consistent database backups? A) They can only be taken when a RECOVERY CATALOG is used. B) They can only be taken if the database Is in ARCHIVELOG mode. C) They can only be tak
15、en If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performedand the backup is taken before the database is reopened. D) They can only be taken by using RMAN commands. E) They can only be taken by using RMAN when the databaseis in MOUNT state. Answer:CEAdministrator CUUG内部OCP题库解析-052-文档2 7/17/1911、Which three are true about UNDO data? A) It is used to roll back failed transactions. B) It is used to rewind a database by using FLASHBACKDATABASE. C) It is used to recover dropped tables by using FLASHBACKTABLE TO BEFOR