CUUG内部OCP题库解析-053-文档4

CUUG内部OCP题库解析-053-文档4题库新特点：oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了，cuug整理了近期的053考题，并进行了讲解。下面的题是（053考试-第6个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1921.You are managing an Oracle Database 11g instance. You want to create aduplicate database for testing purpose.What are the prerequisites for performing the active database duplication?(Choose all that apply.)A. The source database backup must be copied over the net for testdatabase.B. The source database must be run in ARCHIVELOG mode if the database isopen.C. The source database must be shut down cleanly if the database is inmounted state.D. A net service name should be set up and a listener configured with thetarget as well as the source database.Answer: BCD22.An index called ORD_CUSTNAME_IX has been created on theCUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column inthe WHERE clause. You want to check the impact on the performance ofthe queries if the index is not available. You do not want the index to bedropped or rebuilt to perform this test.Which is the most efficient method of performing this task?A. disabling the indexB. making the index invisible C. making the index unusableD. using the MONITORING USAGE clause for the indexAnswer: B11g版本才提供这个功能，这样索引就隐藏起来了，如果把索引隐藏 后发现有性能问题，我们可以立即打开索引：SQL> alter index IDX_T1_TABLE_NAME visible;23.Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBs C. deduplication, encryption, and compression settings for all SecureFile LOBsD. deduplication, encryption, and compression settings only for SecureFile CLOBs Answer: C消除重复数据，加密，压缩适用于所有securefile LOB24.Which of the following information will be gathered by the SQL Test CaseBuilder for the problems pertaining to SQL-related problems? (Choose all thatapply.)A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual dataAnswer: BCD题意：对于与SQL相关的问题，SQL测试用例生成器将收集以下哪些信息？ Building SQL Test CasesFor many SQL-related problems, obtaining a reproducible test case makes iteasier to resolve the problem. Starting with the 11g Release 2 (11.2),The information gathered by SQL Test Case Builder includes the querybeing executed, table and index definitions (but not the actual data),PL/SQL functions, procedures, and packages, optimizer statistics, andinitialization parameter settings.25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive? A. Drop the table.B. Partition the table C. Truncate the table.D. Add a column to the table.E. Rename a column in the table.Answer: CDEFlashback Data Archive开启对DDL的支持： 只支持以下DDL语句：-alter table-truncate table -rename table如果使用了不受支持的DDL语句，可以先用 dbms_flashback_archive.disassociate_fba过程使得表和flashback dataarchive分离，DDL操作完成后使用dbms_flashback_archive.reassociate_fba重新关联27.You are using the flash recovery area (fast recovery area in 11 gRelease 2) to store backup related files in your database.After regular monitoring of space usage in the Mash recovery area. Yo urealize that the flash recovery area is (jetting filled up very fast and it isrunning out of space. Your database flash recovery area is low on specieand you have no more room on disk. Proactively, which two options couldyou use to make more space available in the flash recovery Choose twoA. Change the RMAN archived log deletion policy.B. Use the RMAN CROSSCHECK command to reclaim the archived logspace.C. Change the RMAN retention policy to retain backups for a shorterperiod of time.D. Use OS command to move files from the flash recovery area to someother location Answer: BD28.You have a range-partitioned table in your database. Each partition in thetable contains the sales data for a quarter.The partition related to the current quarter is modified frequently and otherpartitions undergo fewer data manipulations. The preferences for the table areset to their default values. You collect statistics for the table using the followingcommand in regular intervals:SQL> EXECUTEDBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');You need statistics to be collected more quickly. What can you do to achievethis?A. Set DYNAMIC_SAMPLING to level 4.B. Set the STATISTICS_LEVEL parameter to BASIC.C. Set the INCREMENTAL value to TRUE for the partition table.D. Increase the value of STALE_PERCENT for the partition table.Answer: C题意： 在数据库中有一个范围分区表。表中的每个分区包含四分之一的销售数据。与当前季度相关的分区经常被修改，并且其他分区经历较少的数据操作。表的首选项设置为默认值。使用以下命令定期收集表的统计信息： 在IO足够好而11.2.0.4