ocpOracle1z0-053-答案整理.docx

整理过程参考了一末夕阳的博客，复习过程的心得是，一百题看完复习前一部分，同时我还整理了一份打印版本的，上面只有题目，没有答案，建议在电脑上先看答案整理那一份，没有答案的那份打印出来，复习使用，可以有效加强记忆。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 statements 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 produce 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语句最初与计划一起运行，该计划在标准测试配置下已知能产生良好的性能。新应用程序部署：部署新的应用程序模块意味着在系统中引入新的 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 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 Repository (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 保留期中的天数的值，可以调整移动窗口基线的大小。因此，要增加移动窗口的大小，需要先相应地增加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 database, 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 DROP 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你发现当前的重做组联机重做日志文件被损坏。你应该使用哪种说法来解决这个问题？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 below: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:00 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 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 Database 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 also 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 catalog.global scripts:可以针对在恢复目录中注册的任何数据库执行.在import时，如果global scripts与目标方案的global scripts名称相同，则RMAN会重新命名为COPY OFscript_name。7.You need to configure fine-grained access control to external network resources from within yourdatabase. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.Which statement is true regarding the ACL created?A. It is a list of remote database links stored in the XML file that are available to the users of the database.B. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.C. It is a list of users and network privileges stored in the data dictionary according to which a group ofusers can connect to one or more hosts.D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.8.Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?A. It cannot be done in parallel.The safer , easier way to help you pass any IT exams.4 / 193B. It can be done at the table level or partition level.C. It does not require additional storage because the operation is done online.D. Local and global indexes are maintained automatically during the operation.Online redefinition is the only recommended method for migration of BasicFiles LOBs to SecureFiles LOBs.It can be done at the table or partition level.迁移到SecureFiles使用LOB 接口超集，可轻松从BasicFile LOB 进行迁移。迁移到SecureFiles 有两种建议方法：分区交换和联机重新定义。分区交换 需要与表中最大分区相等的额外空间 可在交换期间维护索引 可将工作量分散到多个较小的维护窗口 要求表或分区脱机以执行交换联机重新定义（建议做法） 不要求表或分区脱机 可并行进行 要求额外存储空间等于整个表，并且所有LOB 段均可用 要求重建所有全局索引这些解决方案通常意味着使用输入LOB 列中的数据所用磁盘空间两倍的空间。但是，使用分区和按分区执行这些操作有助于降低所需的磁盘空间。9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedurefor LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitionedtables.如果题目指定为SECUREFILELOBspace usage，则B是正确的。10.Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The mostrecent backup to disk for the TOOLS tablespace was taken on November 3, 2007.The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statementis true regarding the backup of the TOOLS tablespace?A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of the tablespace exists within the seven dayWindow题意：最近的一次TOOLS表空间是 November 3, 2007，November 4, 2007变为只读，November 23, 2007执行RMAN备份。仅当符合保留策略的备份不存在时，备份优化才会让RMAN 备份只读表空间。根据备份优化，如果在November 3, 2007之后的7天内备份，则在rman备份时跳过只读表空间，即TOOLS表空间。如果超过7天，即之前保留的备份已经没有了，再次执行RMAN命令时，此时的TOOLS表空间并没有备份，则执行RMAN命令时，TOOLS表空间也要被备份。故选D。tools这个只读表空间在7天的时间窗口没有备份。11.View the Exhibit to examine the metrics with a threshold. Which statement is true regarding theNumber of Transactions (per second) metric?A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.Oracle使用统计相关性来确定一种自适应阈值时已经突破了度量。B. The statistics for the metric values observed over the baseline time period are not examined todetermine threshold values.C. Oracle determines when an adaptive threshold has been breached based on the maximum valuecaptured by the baseline.D. The total concurrent number of threshold violations, which must occur before an alert is raised for themetric, has been set to zero.The safer , easier way to help you pass any IT exams.5 / 19312.You performed the RMAN database backup having a backupset key number 231 with the KEEPFOREVER option.After some days, you want to change the status of the database backup and you issued the followingcommand:RMANCHANGE BACKUPSET 231 NOKEEP;What is the implication of this command?A. The backup is deleted.B. The backup is marked unavailable.C. The backup overrides the backup retention policy.D. the backup becomes eligible for deletion according to the existing retention policy要删除备份就会根据现有的保留政策13.View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is theSignificance Level threshold type not available in the threshold setting?A. because AWR baseline is not enabledB. because Current Open Cursors Count is not a basic metric因为当前打开的游标数不是一个基本指标C. because the STATISTICS_LEVEL parameter is set to BASICD. because the AWR baseline is a system-defined moving window baseline答案解析：这道题是问，为什么阈值类型没有显著性水平？14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works only in a single database instance environment.安装热补丁程序 应用热补丁程序不需要关闭实例、重新链接Oracle二进制文件或重新启动实例。 OPatch 可用于安装或卸载热补丁程序。 OPatch 可以检测两个热补丁程序之间以及热补丁程序与常规补丁程序之间的冲突15.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. ThePROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recoveryThe safer , easier way to help you pass any IT exams.6 / 193catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executesthe following command to grant privileges to a new user VPC1 using Oracle Database 11g RMANexecutables:RMAN GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;Then you issue the following commands:RMAN CONNECT CATALOG vpc1/oraclecatdb;RMAN SQL EXEC catowner.dbms_rcvcat.create_virtual_catalog;What is the outcome of the above commands?A. They execute and create a virtual catalog for pre-Oracle 11g clients.他们执行,为pre-Oracle 11 g客户创建一个虚拟目录B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packagedprocedure.D. They produce an error because you need to connect to the target database to execute this packagedprocedure.16.Because of a logical corruption in your production database, you wanted to perform Tablespace Pointin Time Recovery (TSPITR). But before you start the recovery, you queried theTS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects thatwould be dropped when you start the recovery by using this method. You want to preserve these objects.Which option must you use to perform TSPITR and preserve the object?A. Perform Export before TSPITR and Import after TSPITRB. Move objects to another schema that has the same tablespace assignedC. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)17.The INV_HISTORY table is created using the command:SQLCREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)partition by range (inv_date) interval(numtoyminterval(1,month) (partition p0values less than (to_date(01-01-2005,dd-mm-yyyy), partition p1 values less than(to_date(01-01-2006,dd-mm-yyyy);The following data has been inserted into the INV_HISTORY table :INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-20064000 5 1-apr-2006 5000You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL ALTER TABLE inv_history MERGE PARTITIONSFOR(TO_DATE(15-feb-2006,dd-mon-yyyy), FOR(TO_DATE(15-apr-2006) INTO PARTITION sys_py;What would be the outcome of this command?A. It executes successfully, and the transition point is set to 1-apr-2006.B. It executes successfully, and the transition point is set to 15-apr-2006.不在同一分区C. It produces an error because the partitions specified for merging are not adjacent.D. It produces an error because the date values specified in the merge do not match the date valuesThe safer , easier way to help you pass any IT exams.7 / 193stored in the table.18.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL SELECT dbms_addm.get_report(my_instance_analysis_mode_task) FROM dual;You want to suppress ADDM output relating to Segment Advisor actions on user SCOTTs segments.What would you do to achieve this?A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.19.A PL/SQL procedure queries only those columns of a redefined table that were unchanged by theonline table redefinition. What happens to the PL/SQL procedure after the online table redefinition?重新定义A. It remains valid.有效的B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the nexttime it is used.C. It becomes invalid for all options of online table redefinition and is automatically recompiled duringonline redefinition of the table.D. It becomes invalid only if the storage parameters have been modified and it automatically getsrevalidated the next time it is used.20.View the Exhibit and examine the resource consumption details for the current plan in use by thedatabase instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource managementD. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited forthe CPU due to resource management, I/O waits, and latch or enqueue contentionThe safer , easier way to help you pass any IT exams.8 / 19321.You are managing an Oracle Database 11g instance. You want to create a duplicate database fortesting 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 test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.A,从活动数据库复制，不需要拷贝备份。错误。B,源数据库必须是归档模式，正确。C，如果数据库是mount状态，那么源数据库一定是shut down cleanly。正确。D，需要建立网络服务名和配置监听。正确。22.An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERStable using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You wantto check the impact on the performance of the queries if the index is not available. You do not want theindex to be dropped 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 index23.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 CLOBsC. deduplication（两分）, encryption（加密）, and compression（压缩） settings for all SecureFile LOBsD. deduplication, encryption, and compression settings only for SecureFile CLOBs24.Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)下面哪个SQL收集的信息将被测试用例生成器的问题用于修饰或说明sql相关问题?A. ADR diagnostic filesB. all the optimizer statistics优化程序统计C. initialization parameter settings初使化参数D. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported onthe table after enabling Flashback Data Archive?A. Drop the table.B. Partition the tableC. Truncate the table.The safer , easier way to help you pass any IT exams.9 / 193D. Add a column to the table.E. Rename a column in the table.26.You are working on a CATDB database that contains an Oracle Database 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 executed the following commands:RMAN CONNECT CATALOG rco11/passwordcatdbRMAN IMPORT CATALOG rcat10/oracleinst1 NO UNREGISTER;Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)A. They import all metadata from the RCAT10 catalog.B. They unregister the database from the RCAT10 catalog.C. They do not register the databases registered in the RCAT10 catalog.D. They register all databases registered in the RCAT10 catalog.27.You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup relatedfiles in your database.After regular monitoring of space usage in the Mash recovery area. You realize that the flash recoveryarea is (jetting filled up very fast and it is running out of space. Your database flash recovery area is lowon specie and you have no more room on disk. Proactively, which two options could you use to makemore 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 log space.C. Change the RMAN retention policy to retain backups for a shorter period of time.D. Use OS command to move files from the flash recovery area to some other location答案解析：您正在使用闪回恢复区（11g第2版中的快速恢复区）在你的数据库中存储与备份相关的文件。在定期监测在糊状恢复区的空间使用情况之后。你会意识到，闪回恢复区被喷射似地非常快地填充起来且运行空间不足， 你的数据库闪回恢复区空间不足，你没有更多的空间在磁盘上。你可以主动使