ocp1Z0-053(501-600).docx

501.Note the output of the following query;SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:ALTER TABLE exchange_rateFLASHBACKARCHIEVE;What is the outcome of this command?A. The table uses the defaultFlashbackData Archive.B. The Flashback Data Archive Is created In the SYSAUX tablespace.C. The Flashback Data Archive is created in the same tablespace where the tables are stored.D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.Answer: A答案解析：实验验证：1、首先创建一个表空间用于存储闪回数据归档sysTEST1107 create tablespace fla_tbs1 2 datafile /u01/app/oracle/oradata/test1107/fla_tbs01.dbf size 10M;Tablespace created.2、创建闪回数据归档sysTEST1107 create flashback archive fla1 tablespace fla_tbs1 quota 10M retention 1 year;Flashback archive created.3、查询有哪些闪回数据归档以及其状态。sysTEST1107 select FLASHBACK_ARCHIVE_NAME,STATUS from DBA_FLASHBACK_ARCHIVE;FLASHBACK_ARCHIVE_NAME STATUS- -FLA14、对scott.dept表启用闪回数据归档，报错，因为没有指定默认闪回归档。sysTEST1107 alter table scott.dept flashback archive;alter table scott.dept flashback archive*ERROR at line 1:ORA-55608: Default Flashback Archive does not exist5、将FLA1指定为默认闪回数据归档。sysTEST1107 alter flashback archive FLA1 set default;Flashback archive altered.6、查询，此时须注意，status栏位下面的有DEFAULT的状态。sysTEST1107 select FLASHBACK_ARCHIVE_NAME,STATUS from DBA_FLASHBACK_ARCHIVE;FLASHBACK_ARCHIVE_NAME STATUS- -FLA1 DEFAULT7、对表启用闪回数据归档，成功。sysTEST1107 alter table scott.dept flashback archive;Table altered.对于题中的显示，FLA1的状态栏位为空值，即没有指定FLA1为默认的闪回数据归档，所以，此题题库给的答案是错的。正确答案为D.B答案：这里没有说闪回数据归档被创建在哪个表空间，可以根据DBA_FLASHBACK_ARCHIVE_TS;来查询，此处没有提供。sysTEST0924 select * from DBA_FLASHBACK_ARCHIVE_TS;FLASHBACK_ARCHIVE_NAME FLASHBACK_ARCHIVE# TABLESPACE_NAME QUOTA_IN_MB- - - -FLA1 1 FLA_TBS1 10502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.1) Restore the corrupted redo log group.2) Restore from a whole database backup.3) Perform incomplete recovery.4) Relocate by renaming the member of the damaged online redo log group to a new location.5) Open the database with the RESETLOGS option.6) Restart the database instance.7) Issue a checkpoint and clear the log.Identify the option with the correct sequential steps to accomplish the task efficiently.A. 1, 3, 4, and 5B. 7, 3, 4. and 5C. 2, 3, 4, and 5D. 7, 4, 3. and 5E. Only 6 is requiredAnswer: B答案解析：参考：/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90049B为正确答案Recovering After Losing All Members of an Online Redo Log GroupIf a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure and the archiving mode of the database.If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not.Table 30-4outlines the various recovery scenarios.Table 30-4 Recovering After the Loss of an Online Redo Log GroupIf the Group Is.Then.And You Should.InactiveIt is not needed for crash recoveryClear the archived or unarchived group.ActiveIt is needed for crash recoveryAttempt to issue a checkpoint and clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.CurrentIt is the redo log that the database is currently writing toAttempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.Recovering from Loss of Active Logs in ARCHIVELOG ModeIn this scenario, the database archiving mode isARCHIVELOG.To recover from loss of an active online redo log group in ARCHIVELOG mode:Begin incomplete media recovery, recovering up through the log before the damaged log.Ensure that the current name of the lost redo log can be used for a newly created file. If not, then rename the members of the damaged online redo log group to a new location. For example, enter:ALTER DATABASE RENAME FILE /disk1/oradata/trgt/redo01.log TO /tmp/redo01.log;ALTER DATABASE RENAME FILE /disk1/oradata/trgt/redo02.log TO /tmp/redo02.log;Open the database using theRESETLOGSoption:ALTER DATABASE OPEN RESETLOGS;503.Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.)A. You can use RMAN stored scripts.B. Recovery is faster if data is stored in catalog in addition to the control file.C. You can store backup Information of all registered databases in one place.D. Database backups are automatically deleted when they are older than the specified time period.Answer: AC案解析：参考：/rlhua/article/details/13169205RMAN 资料档案库数据始终存储在目标数据库的控制文件中。此外，它也可以存储在一个名为“恢复目录”的单独数据库中。恢复目录会在单独的数据库中保留备份信息，这在控制文件丢失时尤为有用。这样你可以存储更长的备份历史记录，比基于控制文件的资料档案库所存储的历史记录还要长。使用一个恢复目录可存储多个目标数据库的信息。恢复目录还可用来存放RMAN 存储脚本，这些脚本是RMAN 命令的序列。如果你的备份管理要求很简单，则Oracle 建议你使用控制文件选项而不要使用恢复目录。拥有恢复目录意味着你需要管理并备份其它数据库。因此，只有在可利用恢复目录所提供的优点（如较长的备份保留时间）时，才使用恢复目录。504.View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?A.The command performs the recovery and closes the failures.B.The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).C.The command only displays the advice and the RMAN script required for repair.D.The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.Answer: D 505.You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?A. MAXSETSIZE TO 2;B. DEVICE TYPE DISK PARALLELISM 2;C. RETENTION POLICY TO REDUNDANCY 2;D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Answer: C题目解答： 冗余数为 2,可确保备份文件至少 2 份才有效备份。D 也能实现备份为 2 份值不过是一个备份集下有两个一样的备份文件在不同的备份片中。但默认不能用 必须使用 format 参数指定备份路径506.Examine the following ALTER command;SQL ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops within the disk group.B. It adds previously dropped disks back into the disk group.C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.D. It mounts disks in the disk group for which the drop-disk operation has already been completed.E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.Answer: A答案解析：参考：/cd/E11882_01/server.112/e41084/statements_1007.htm#SQLRF52639undrop_disk_clauseUse this clause tocancel the drop of disks from the disk group. You can cancel the pending drop of all the disks in one or more disk groups (by specifyingdiskgroup_name) or of all the disks in all disk groups (by specifyingALL).This clause is not relevant for disks that have already been completely dropped from the disk group or for disk groups that have been completely dropped. This clause results in a long-running operation. You can see the status of the operation by querying theV$ASM_OPERATIONdynamic performance view.507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)A. redo logsB. control fileC. temporary files of temporary tablespaceD. the latest backup of only the damaged data fileE. the latest backup of all the data files In the USERS tablespaceAnswer: ABD答案解析：对比625题：/rlhua/article/details/19173169此题对比625题，缺少一个F选项：F. Archive Logs since the latest backup to point of failure从以下实验看出，redo log是用来介质恢复用的。the latest backup of only the damaged data file用来做转储用。Archive Logs since the latest backup to point of failure应用归档日志恢复到故障点这里要求选三个，从用排除法，CE是不需要用到的。故正确答案应为ADF508.You want to set the following Initialization parameters for your database InstanceLOG_ARCHIVE_DEBT_1 = ,LOCATION=/disk1/archLOG_ARCHIVE_DBST_2 = ,LOCATION=/disk2/archLOG_ARCHIVE DBST_3 = ,LOCATION=/disk3/archLOG_ARCHIVE DBST_4 = ,LOCATION=/disk3/archIdentify the statement that correctly describes this setting.A. The MANDATORY location must be a flash recovery area.B. The optional destinations may not use the flash recovery area.C. This setting is not allowed because the first destination is not set as MANDATORY.D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in thefourth destination.Answer: D答案解析：参考：618题：/rlhua/article/details/13998731此题题意有问题，第四个路径应为LOG_ARCHIVE_DEST_4 = LOCATION=/disk4/archMANDATORY如果两个路径相同，如题中3和4是一样的/disk3/arch，是不对的。sysTEST1107 alter system set log_archive_dest_1=LOCATION=/u01/rmanbak/d1;System altered.sysTEST1107 alter system set log_archive_dest_2=LOCATION=/u01/rmanbak/d1;alter system set log_archive_dest_2=LOCATION=/u01/rmanbak/d1*ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameterLOG_ARCHIVE_DEST_1 destination509.Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)A. A single SQL statement provided by a userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive resourcesAnswer: CD答案解析：参考：/rlhua/article/details/13021985 使用SQL 优化指导可分析SQL 语句，并获得性能建议。 SQL 优化指导分析的来源： 顶级活动：分析当前处于活动状态的顶级 SQL 语句 SQL 优化集：分析用户提供的一组 SQL 语句 以往的SQL (AWR)：分析 AWR 快照收集的 SQL 语句中的语句排除法，选CD510.You executed the following command in Recovery Manager (RMAN):RMAN REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB. a list of files requiring more than 3 days of archive logs to applyC. a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD. a list of files for which a backup has already been performed in the last three days and which isrequired to be backed up again based on the high number of transactions performed on themAnswer: A 题目解答：列出 3 天内没有备份而要求备份的文件清单注意 B 在非归档下是错误的。511.You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:LOG_ARCHIVE_DEST 1 = ,LOCATION=/disk1/arch MANDATORYLOG _ARCHIEVE_DEST 2 = ,LOCATION=/disk2/archLOG_ARCHIVK_DEST_3 = ,LOCATION=/diSk3/archLOG_ARCH1VK_DEST_4 = LOCATION=/disk4/archLOG_ARCHIVE_MIN-SUCCEED_DEST = 2While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch?A. The online redo log file Is not allowed to be overwritten.B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.Answer: D答案解析：参考：/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN11346题中共有4个LOG _ARCHIEVE_DEST，而LOG_ARCHIVE_MIN-SUCCEED_DEST = 2，即意味着必须有两个能归档成功，而LOG_ARCHIVE_DEST 1是指定MANDATORY，即要求它必须归档成功，但此时LOG_ARCHIVE_DEST 1不可用，根据LOG_ARCHIVE_MIN-SUCCEED_DEST = 2，保证接下来的两个归档地址必须归档成功。512.Which two statements correctly describe the relationship among the Scheduler components: job,program, and schedule? (Choose two)A.A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as part of a schedule definitionD. A program and schedule can be specified as part of a job definitionAnswer: BD答案解析：参考：/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12374/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357正确答案BD调度程序使用以下基本组件：“作业”指定要执行的操作。它可以是PL/SQL 过程、纯二进制可执行文件、Java 应用程序或Shell 脚本。可以将程序（内容）和调度（时间）指定为作业定义的一部分，也可以改用现有的程序或调度。可以使用作业的参数来定制其运行时行为。“调度”指定作业的执行时间和次数。调度可以基于时间或事件。可以为作业定义调度，方法是使用一系列日期、一个事件，或两者相结合，以及表示重复间隔的附加说明。可以单独存储作业的调度，然后对多个作业使用同一个调度。 “程序”是有关特定可执行文件、脚本或过程的元数据集合。自动作业将执行某个任务。使用程序，无需修改作业本身即可修改作业任务或者“内容”。可以定义程序的参数，使用户可以修改任务的运行时行为。513.What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the aboveAnswer: A答案解析：参考：/rlhua/article/details/12659769表空间时间点的恢复是使用rman的recove名来来恢复的如：执行完全自动执行的TSPITR1. 配置在目标实例上执行TSPITR 所需的通道。2. 使用AUXILIARYDESTINATION选项指定辅助目标。RMAN CONNECT TARGETRMANRECOVERTABLESPACE users, example UNTIL TIME 2007-06-29:08:00:00 AUXILIARY DESTINATION /u01/app/oracle/oradata/aux;3. 备份恢复的表空间并使它们联机。执行完全自动执行的TSPITR 时，还必须： 配置在目标实例上执行TSPITR 所需的任何通道 指定RMAN 用于数据文件辅助集和其它辅助实例文件的目标在TSPITR 完成之后，备份恢复的表空间并使它们联机。执行TSPITR 之后，不能使用TSPITR 之前创建的参与执行TSPITR 的表空间的备份。514.A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?A. Flashback DropB. Flashback QueryC. Flashback Versions QueryD. Flashback Transaction QueryE. Flashback TableAnswer: E 答案解析：参考：/rlhua/article/details/12404577针对使用了错误的where子句进行更新，使用闪回表就可以了。515.A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?A. Initiate an incomplete recovery operation using RMAN. B. Copy the table from a development database.C. Advise the user to rekey the data.D. Perform a Flashback Drop operation.E. Perform a Flashback Recovery operation.Answer: D 答案解析：参考：闪回删除：/rlhua/article/details/12407737使用FLASHBACK TABLE命令，可以在无需使用时间点恢复的情况下，还原DROP TABLE语句的结果。注：初始化参数RECYCLEBIN用于控制闪回删除功能是打开(ON) 还是关闭(OFF)。如果将该参数设置为OFF，则删除的表不会进入回收站。如果将该参数设置为ON，则删除的表将进入回收站，并且可以进行恢复。默认情况下，RECYCLEBIN设置为ON。使用FLASHBACK TABLE . TO BEFORE DROP命令从回收站恢复表及其所有可能的从属对象。可以指定表的原始名称或删除对象时分配给对象的系统生成名称。516.In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.)A. SQL textB. Shared server requests (Oracle MTS)C. Bind variable valuesD. Information about transactionsE. Remote DESCRIBE and COMMIT operationsAnswer: ACD答案解析：参考：/cd/E11882_01/server.112/e41481/dbr_intro.htm#RATUG105517.Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks thatare not corrupt.C. Uncorrupted blocks from the flashback logs may be used to speed recovery.D. The database can be in NOARCHIVELOG mode.E. None of the above.Answer: BC答案解析：参考：/cd/E11882_01/backup.112/e10642/rcmblock.htm#BRADV89784Missing Redo During Block RecoveryLike data file media recovery, block media recovery cannot generally survive a missing or inaccessible archived log, although it attempts restore failover when looking for usable copies of archived redo log files, as described inRestore Failover. Also, block media recovery cannot survive physical redo corruptions that result inchecksumfailure. However, block media recovery can survivegapsin the redo stream if the missing or corrupt redo records do not affect the blocks being recovered. Whereas data file recovery requires an unbroken series of redo changes from the beginning of recovery to the end, block media recovery only requires an unbroken set of redo changes for the blocks being recovered.Note:Each block is recovered independently during block media recovery, so recovery may be successful for a subset of blocks.When RMAN first detects m