《CUUG内部OCP题库解析-053-文档4》由会员分享，可在线阅读，更多相关《CUUG内部OCP题库解析-053-文档4（20页珍藏版）》请在金锄头文库上搜索。
1、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.Wh
2、at 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
3、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:SQLCREATE INDEX ord_cust
4、name_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 effic
5、ient 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 accomplis
6、hed 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 comp
7、ression 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. i
8、nitialization 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
9、. 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 Fla
10、shback 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的支持： 只支持
11、以下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
12、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 opti
13、ons 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 mov
14、e 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 man
15、ipulations. 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 ac
16、hievethis?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
