CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档8题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。下面的题是(052考试-第8个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档8 7/17/19七. Storage Structures19. Which three structures can span multiple data les?A) migrated rows B) table extentsC) temporary segment extentsD) index extents E) chained rowsF) segments Answer:AEFAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1920. Which structure can span multiple data les? A) a bigle tablespaceB) a permanent tablespaceC) a segmentD) a temporary tablespace E) an extent Answer:CAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1921. Which four database objects never have any segments? A) A partitioned indexB) A view selecting from a populated tableC) An empty indexD) An Oracle Loader type external tableE) An empty tableF) A view selecting from an empty tableG) An Oracle Data Pump type external tableAnswer:BDFGAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1922. Which three of these must be accessible to keep a database open?A) Control le.B) All members of a redo log group.C) SYSTEM tablespace.D) SYSAUX tablespace.E) spleAnswer:ABCAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1923. Which two of these must be available READ/WRITE to keep a databaseopen?A) all copies of the control le. B) the password le.C) all members of the current redo log group. D) sple.E) TEMP tablespaceF) SYSAUX tablespaceAnswer:ACAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1924. Archivelog mode is enabled for your database andDB_CREATE_FILE_DEST is set to /u01/oracle/ db01.The parameters, DB_CREATE_ONLINE_LOG_DESN_n and DB_RECOVERY_FILE_DEST, and not specied.Which four are stored in the location specied by DB_CREATE_FILE_DEST? A) audit logs B) control les C) redo logs D) audit les E) data lesF) archived redo logs G) temp lesH) RMAN backupsAnswer:BCEGAdministrator CUUG内部OCP题库解析-052-文档8 7/17/19八. Checkpoint 25. When does an incremental checkpoint occur ? A) when an online redo log switch occurs. B) when DBWn writes dirty buffers as part of its normalprocessing.C) when the ALTER SYSTEM CHECKPOINT statement is executed.D) when a user tablespace is tabken ofine.Answer: AAdministrator CUUG内部OCP题库解析-052-文档8 7/17/19九. Inventory Directory24. Which two are true about the Inventory directory? A) It is shared by all Oracle software installations on a single server. B) It is required only for Oracle Grid Infrastructure and Oracle Database software Installations.C) It can be created only if the ORACLE_BASE environment variable isset.D) It should be created before installing Oracle software for the rst time on a server.E) It is owned by the oinstall group, which must be created before installing Oracle software for the rst time on a server.Answer:ADAdministrator CUUG内部OCP题库解析-052-文档8 7/17/19. Administer Database25. which four are true about the tools used to administer Oracle database? A) the Data Pump utility can be used to load data from text les.B) SRVCTL can be used to shut down Oracle instances.C) SQL* Plus can be used to create databases.D) SQL*Plus can be used to startup Oracle instances.E) DBCA can be used to upgrade databases.F) RMAN can be used to startup Oracle instances.Answer:BCDFAdministrator CUUG内部OCP题库解析-052-文档8 7/17/19一.Archivelog26. Which state must a database be to enable ARCHIVELOG ? A) NOMOUNTB) OPEN IN READ WRITE modeC) OPEN IN READ ONLY modeD) OPEN IN RESTRICTED modeE) MOUNTAnswer: EAdministrator CUUG内部OCP题库解析-052-文档8 7/17/19二.Data Pump27. Which two can be exported by a non-administrative account by using Data Pump?A) directory objectsB) tablesC) tablespacesD) schemas E) DatabaseAnswer:BDAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1928. Where is an expdp operation tracked?A) dump les B) control le C) log lesD) Automatic Diagnostic Repository(ADR) E) master table (MT)Answer:EAdministrator CUUG内部OCP题库解析-052-文档8 7/17/1929. Which two are true about Oracle Data Pump in Oracle Database 11gRelease 2?A) If the directory used in the export operation has existing dump les, it overwrites them.B) It allows encryption to be performed without using a password. C) It supports the export of specic views as tables.D) It allows compression levels to be dened for the export. E) It supports the renaming of tables during import.Answer:AE11g expdp工具支持压缩和加密功能,但是加密的时候需要用到密码。压缩的级别分别是ALL, DATA_ONLY, METADATA_ONLY,DEFAULT 或 NONE。默认是会采用DEFAULT的压缩方式采用METADATA_ONLY级别压缩。加密的级别是ALL,DATA_ONLY, METADATA_ONLY,ENCRYPTED_COLUMNS_ONLY 或 NONE。如果当前的dump文件已经存在,需要使用参数REUSE_DUMPFILES y 覆盖目标转储文件Administrator CUUG内部OCP题库解析-052-文档8 7/17/1930. Which two statements are true regarding the Oracle Data Pump export and import operations?(choose two)A) You cannot export data from a remote database.B) You can rename tables during an import operation.C) You can overwrite existing dump