052题库解析 最新15道题 题库新特点： 最原有的题库基础上有添加了新的题库 每周五晚8点-直播地址：ke.qq.com/course/326223 ocp考试讨论群：836361015 验证：ocp CUUG整理，官网：www.cuug.com 七. Storage Structures 19. Which three structures can span multiple data fi les？ A) migrated rows B) table extents C) temporary segment extents D) index extents E) chained rows F) segments Answer：AEF 20. Which structure can span multiple data fi les? A) a bigfi le tablespace B) a permanent tablespace C) a segment D) a temporary tablespace E) an extent Answer：C 21. Which four database objects never have any segments？ A) A partitioned index B) A view selecting from a populated table C) An empty index D) An Oracle Loader type external table E) An empty table F) A view selecting from an empty table G) An Oracle Data Pump type external table Answer：BDFG 22. Which three of these must be accessible to keep a database open? A) Control fi le. B) All members of a redo log group. C) SYSTEM tablespace. D) SYSAUX tablespace. E) spfi le Answer：ABC Correct Answer: D 23. Which two of these must be available READ/WRITE to keep a database open? A) all copies of the control fi le. B) the password fi le. C) all members of the current redo log group. D) spfi le. E) TEMP tablespace F) SYSAUX tablespace Answer：AC 24. 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 specifi ed. Which four are stored in the location specifi ed by DB_CREATE_FILE_DEST? A) audit logs B) control fi les C) redo logs D) audit fi les E) data fi les F) archived redo logs G) temp fi les H) RMAN backups Answer：BCEG 八. 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 normal processing. C) when the ALTER SYSTEM CHECKPOINT statement is executed. D) when a user tablespace is tabken offl ine. Answer： A 九. Inventory Directory 24. 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 fi rst time on a server. E) It is owned by the oinstall group, which must be created before installing Oracle software for the fi rst time on a server. Answer：AD . Administer Database 25. 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 fi 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：BCDF 一.Archivelog 26. Which state must a database be to enable ARCHIVELOG ? A) NOMOUNT B) OPEN IN READ WRITE mode C) OPEN IN READ ONLY mode D) OPEN IN RESTRICTED mode E) MOUNT Answer: E 二.Data Pump 27. Which two can be exported by a non-administrative account by using Data Pump? A) directory objects B) tables C) tablespaces D) schemas E) Database Answer：BD 28. Where is an expdp operation tracked? A) dump fi les B) control fi le C) log fi les D) Automatic Diagnostic Repository(ADR) E) master table (MT) Answer：E 29. 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 fi les, it overwrites them. B) It allows encryption to be performed without using a password. C) It supports the export of specifi c views as tables. D) It allows compression levels to be defi ned for the export. E) It supports the renaming of tables during import. Answer：AE 11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。压缩的 级别分别是ALL, DATA_ONLY, METADATA_ONLY,DEFAULT 或 NONE。默认是会采用 DEFAULT的压缩方式采用METADATA_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 fi les during an export operation. D) You can compress the data during export but not the metadata because it is not supported. Answer: BC 31. 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.1og