OCP最新考试题库解析之052考试原题-8-20180727
052题库解析,最新15道题 052-题库解析-8-20180727,题库新特点:, 最原有的题库基础上有添加了新的题库 每周五晚8点-直播地址:ke.qq.com/course/326223 ocp考试讨论群:836361015 验证:ocp CUUG整理,官网:www.cuug.com,七. Storage Structures 19. Which three structures can span multiple data 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 les? A) a bigle 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 le.,B) All members of a redo log group. C) SYSTEM tablespace. D) SYSAUX tablespace. E) sple,Answer:ABC,23. Which two of these must be available READ/WRITE to keep a database open?,A) all copies of the control le. B) the password le. C) all members of the current redo log group. D) sple. 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 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 les F) archived redo logs G) temp 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 ofine. 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 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: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 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 les B) control le C) log 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 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: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 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 Which three objects will be exported? A) EMP_PK B) EMP_SEQ C) EMP_OPS_PKG D) EMP_VU E) EMP_IDX F) EMP_TRG,