2018年OCP 052最新考试题库解析-20180727题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG七. Storage Structures19. Which three structures can span multiple data files？A) migrated rowsB) table extentsC) temporary segment extentsD) index extentsE) chained rowsF) segmentsAnswer：AEF20. Which structure can span multiple data files?A) a bigfile tablespaceB) a permanent tablespaceC) a segmentD) a temporary tablespaceE) an extentAnswer：C21. 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：BDFG22. Which three of these must be accessible to keep a database open?A) Control file.B) All members of a redo log group.C) SYSTEM tablespace.D) SYSAUX tablespace.E) spfileAnswer：ABC23. Which two of these must be available READ/WRITE to keep a database open?A) all copies of the control file.B) the password file.C) all members of the current redo log group.D) spfile.E) TEMP tablespaceF) SYSAUX tablespaceAnswer：AC24. Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’.The parameters, DB_CREATE_ONLINE_LOG_DESN_n and DB_RECOVERY_FILE_DEST, and not specified.Which four are stored in the location specified by DB_CREATE_FILE_DEST?A) audit logsB) control filesC) redo logsD) audit filesE) data filesF) archived redo logsG) temp filesH) RMAN backupsAnswer：BCEG八. Checkpoint25. When does an incremental checkpoint occur ?A) when an online redo log switch occurs.B) when DBWn writes dirty buffers as part of its normal processing.C) when the ALTER SYSTEM CHECKPOINT statement is executed.D) when a user tablespace is tabken offline.Answer：A九. 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 is set.D) It should be created before installing Oracle software for the first time on a server.E) It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server.Answer：AD⼗. 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 files.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：BCDF⼗一.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: E⼗二.Data Pump27. Which two can be exported by a non-administrative account by using Data Pump?A) directory objectsB) tablesC) tablespacesD) schemasE) DatabaseAnswer：BD28. Where is an expdp operation tracked?A) dump filesB) control fileC) log filesD) Automatic Diagnostic Repository(ADR)E) master table (MT)Answer：E29. Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?A) If the directory used in the export operation has existing dump files, it overwrites them.B) It allows encryption to be performed without using a password.C) It supports the export of specific views as tables.D) It allows compression levels to be defined for the export.E) It supports the renaming of tables during import.Answer：AE11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。

压缩的级别分别是ALL, DATA_ONLY, METADATA_ONLY,DEFAULT 或NONE。

默认是会采用DEFAULT的压缩方式采用METADAT A_ONLY级别压缩。

加密的级别是ALL,DATA_ONLY, METADATA_ONLY,ENCRYPTED_COLUMNS_ONLY 或NONE。

如果当前的dump文件已经存在，需要使用参数REUSE_DUMPFILES ＝y 覆盖目标转储文件30. 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 files during an export operation.D) You can compress the data during export but not the metadata because it is not supported. Answer: BC31. Examine these facts about objects in the SYSTEM schema:1.EMP is a table.2.EMP_PK is a primary key constraint on EMP.ENO.3.EMP_IDX is an index on EMP.MGR_NO.4.EMP_SEQ is a sequence used to generate values for EMP.ENO.5.EMP_OPS_PKG is a package that performs DML operations on EMP.6.EMP_VU is a view on EMP.7.EMP_TRG is a trigger on EMP.Examine this command:$ expdp system/oracle \> FULL =Y \> EXCLUDE=TABTLE:"= 'EMP' "\> DIRECTORY=data_pump_dir \> DUMPFILE=full_db.dmp \> LOGFILE=full_db.1ogWhich three objects will be exported?A) EMP_PKB) EMP_SEQC) EMP_OPS_PKGD) EMP_VUE) EMP_IDXF) EMP_TRGG) EME_FNAnswer：BCD ( 已验证）expdp system/oracle DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott EXCLUDE=TABLE:\"IN\(\'EMP\'\)\" SCHEMAS=scott如果在导出的过程中排除了一张表，那么跟这张表相关的数据就不会导出，比如表的结构、数据、索引、约束、触发器等。