《ocpOracle.1z0_053_答案整理》由会员分享，可在线阅读，更多相关《ocpOracle.1z0_053_答案整理（196页珍藏版）》请在金锄头文库上搜索。
1、. . . .整理过程参考了一末夕阳的博客，复习过程的心得是，一百题看完复习前一部分，同时我还整理了一份打印版本的，上面只有题目，没有答案，建议在电脑上先看答案整理那一份，没有答案的那份打印出来，复习使用，可以有效加强记忆。1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statem
2、ents describe the consequences? (Choose two.)A. The plan baselines can be evolved over time to produce better performance.B. The newly generated plans are directly placed into the SQL plan baseline without being verified.C. The new SQL statements initially run with the plans that are known to produc
3、e good performance under standard test configuration.D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.当部署一个新的应用模块时，软件供应商与用于被引入的新SQL的适当的SQL计划基线一起运送应用软件。哪两个语句描述了后果？A,计划基线可以随着时间的推移演变，产生更好的性能。C,新的SQL语句最初与计划一起运行，该计划在标准测试配置下已知能产生良好的性能。新应
4、用程序部署：部署新的应用程序模块意味着在系统中引入新的 SQL 语句。软件供应商可以将应用程序软件与新引入的SQL 语句的相应SQL 计划基线一起提供。由于存在计划基线，新的SQL 语句最初将与已知在标准测试配置下具有良好性能的计划一起运行。但是，如果客户系统配置与测试配置有很大的差异，则计划基线可随时间演化以产生更好的性能。2.You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive
5、 threshold.Which statement factors in this consideration while increasing the size of the moving window.?A. The collection level for the AWR should be set to BASIC.B. The moving window size must be less than Undo Retention.C. The moving window size should be greater than the Automatic Workload Repos
6、itory (AWR) retention period.D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.移动窗口基线Oracle Database 会自动维护一个系统定义的移动窗口基线。系统定义的移动窗口基线的默认窗口大小为当前的AWR 保留期（默认为八天）。如果计划使用自适应阈值，则可考虑使用较大的移动窗口（如30 天），以便精确地计算阈值。通过将移动窗口中的天数更改为等于或小于AWR 保留期中的天数的值，可以
7、调整移动窗口基线的大小。因此，要增加移动窗口的大小，需要先相应地增加AWR 保留期。这种系统定义的基线提供了一个现成的默认基线，EM 的性能屏幕可对照当前的数据库性能对性能进行比较。注：在Oracle Database 11g中，快照数据的默认保留期已经从七天更改为八天，以确保捕获整周的性能数据。3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the datab
8、ase, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: D:REDO01.LOGYou discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?A. ALTER DATABASE DR
9、OP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER D:REDO01.LOG;你的数据库在归档记录模式。你有两个在线重做日志组，其中每个都包含一个重做成员。当您尝试启动数据库时，您会收到以下错误：ORA-00313：线程1日志组1成员打开失败ORA-00312：联机日志1线程1：D： REDO01.LOG你发现当前的重做组联机重做日志文件被损坏。你应该使
10、用哪种说法来解决这个问题？4.Which three components does the Scheduler use for managing tasks within the Oracle environment?(Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedure在Oracle环境调度程序为管理任务使用哪三个组件？A. a job作业B. a program程序C. a schedule调度5.Examine the section of the Health Check report given b
11、elow:DBMS_HM.GET_RUN_REPORT(HM_RUN_1061)The safer , easier way to help you pass any IT exams.3 / 193Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :2007-05-12 22:11:20.835135 -07:0
12、0 Error Encountered : 0Source Incident Id : 7418Number of Incidents Created :0Which two statements are true regarding the Health Check report? (Choose two.)A. Health Check was performed manually.B. Health Check was performed to check the disk image block corruptions.C. Health Check was performed to
13、check interblock and intersegment corruption.D. Health Check was performed to verify the integrity of database files and report failures.E. Health Check was performed by the Health Monitor automatically in response to a critical error.6.You are working on a CATDB database that contains an Oracle Dat
14、abase version 11.1 catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalogschema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,into the recovery catalog owned by RCO11. You a
15、lso want to deregister them from the catalog after import.You executed the following commands to achieve this:RMAN CONNECT CATALOG rco11/passwordcatdbRMAN IMPORT CATALOG rcat10/oracleinst1 DBID=1423241,1423242;What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10catalog?A. The scripts in the RCO11 catalog are overwritten.B. RMAN renames the local stored scripts in the RCO11 catalog.C. The RMAN session in which the command is executed aborts.D. RMAN renames the global scripts that are imported from the RCAT10 cat
