OCP认证052考试原题题库解析-2-2018VIP

052题库解析 最新15道题 题库新特点： 更加灵活，题库的顺序与考试时的顺序每场都在变化 更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案 不断有新的考题出现，目前最新已经更新到130道题 每周五晚8点-直播地址：/course/326223 ocp考试讨论群：836361015 验证：ocp CUUG整理，官网： 1、.Which two are true about the Archive (ARCn) processes? A) They automatically delete obsolete archive logs to make 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 ARCHTVELOC mode. E) They create archivelogs after every log switch. Answer:DE 2、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 the 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:DF 3、Which structure can span multiple data files? A) a permanent tablespace B) a bigfile tablespace C) a temporary tablespace D) a segment E) an extent Answer:ACD 4、For which requirement should you configure shared servers? A) accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited 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-load operations in a DSS environment with limited memory E) using Recovery Manager (RMAN) to recover a database Answer:A 5、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) size of archivelogs E) size of existing RMAN backupsets F) UNDO_RETENTION value Answer:AC 6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select 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 privileged operating system groups that are used for OS authentication C) creation of a general purpose database D) creation of an ASM disk group and registration of ASM components with Oracle Restart Answer:D 7、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 do not support partitioning. D) They may have Indexes. E) DML operations may be performed on external tables. Answer:C 8、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 Influenced 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:AB 9、Which is true about 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 is manually configured. D) It only contains the alert log and trace files for background processes. Answer:A 10、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 taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and 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 database is in MOUNT state. Answer:CE 11、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 FLASHBACK DATABASE. C) It is used to recover dropped tables by using FLASHBACK TABLE TO BEFORE DROP. D) It is used to enable ROLLBACK statements to roll back uncommitted updates. E) It is used to provide read consistency. F) It is used during online backups to guarantee their consistency. Answer:ADE 12、Which two types of Information can be found in the alert log? A) instance recovery details B) a record of all DDL statements performed by non-DBA users C) a record of all actions performed by SYS and SYSTEM D) critical errors encountered by background processes E) values of all Initialization parameters whenever an Instance Is restarted Answer:AD 13、Which two are true about AWR snapshots? A) They are stored In the SYSAUX tablespace. B) They are not generated if STATISTICS_LEVEL Is set to TYPICAL. C) They can be modified by using DMLs. D) They can be retained forever. E) They are always created automatically. Answer:AD 14、Which command is used to display files that no longer conform to the backup retention policy? A) REPORT OBSOLETE B) SHOW DATAFILE BACKUP COPIES C) CROSSCHECK BACKUP D) LIST EXPIRED BACKUP Answer:A 15、Which two are true about space management in tablespaces? A) Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other. B) Locally managed tablespaces track adjacent f