OCP读书笔记(22)

tonwei139

　　101.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
　　A. The user has dropped an important table that needs to be recovered.
　　B. The database files are corrupted when the database is open.
　　C. You are not able to start up the database instance because the required database files are missing.
　　D. The archived log files are missing for which backup is not available.
　　Answer: B, C
　　104.You are managing an Oracle Database 11g ASM instance having three disks in a disk group with
　　ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group
　　becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose
　　all that apply.)
　　A. The disk is immediately dropped from the disk group.
　　B. The ASM tracks the extents that are modified during the outa
　　C. The ASM migrates the extents from the unavailable disk to the remaining disks.
　　D. The disk automatically goes offline.
　　Answer: B, D
　　105.Which statements are true regarding table compression? (Choose all that apply.)
　　A. It saves disk space and reduces memory usage.
　　B. It saves disk space but has no effect on memory usage.
　　C. It incurs extra CPU overhead during DML as well as direct loading operations.
　　D. It incurs extra CPU overhead during DML but not direct loading operations.
　　E. It requires uncompress operation during I/O.
　　Answer: A, C
　　108.You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group
　　DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)
　　A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
　　B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
　　C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
　　D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
　　Answer: B, C, D
　　109.Which statement describes the effect of table redefinition on the triggers attached to the table?
　　A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
　　B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
　　C. All triggers on the table remain valid.
　　D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
　　Answer: A
　　116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
　　A. It can be used to back up all data on ASM disks.
　　B. It can be used to recover the damaged ASM disk group along with the data.
　　C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
　　D. It can be used to re-create the ASM disk group with its attributes.
　　Answer: C, D
　　Metadata backup and restore, so it has nothing to do with data. The options related to data is not correct.
　　118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
　　A. SQL statements that are part of the AWR baseline only
　　B. SQL statements based on the AWR top SQL identification
　　C. SQL statements that are part of the available SQL Tuning Set (STS) only
　　D. SQL statements that are available in the cursor cache and executed by a user other than SYS
　　Answer: B
　　120.You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
　　A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
　　B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
　　C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
　　D. ASM compatibility controls which features for the ASM will be enabled.
　　Answer: A, B, D
Disk Group Compatibility Attributes
　　The disk group compatibility attributes specify the disk group compatibility settings for Oracle ASM and database instances. These attributes are described under the following topics:

COMPATIBLE.ASM
　　The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk. The format of other file contents is determined by Oracle ASM Dynamic Volume Manager (Oracle ADVM) and the database instance.
　　For Oracle ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.ASM attribute when using the SQL CREATE DISKGROUP statement, the ASMCMD mkdg command, and Oracle Enterprise Manager Create Disk Group page. When creating a disk group with ASMCA, the default setting is 11.2.

COMPATIBLE.RDBMS
　　The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
　　For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
　　For Oracle ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.RDBMS attribute when using the SQL CREATE DISKGROUP statement, the ASMCMD mkdg command, ASMCA Create Disk Group page, and Oracle Enterprise Manager Create Disk Group page.
COMPATIBLE.ADVM
　　The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
　　By default, the value of the COMPATIBLE.ADVM attribute is empty until set.
　　121.Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)
　　A. It creates jobs without considering the priorities associated with them.
　　B. It translates tasks into jobs for execution by the scheduler.
　　C. It determines the list of jobs that must be created for each maintenance window.
　　D. It is spawned by the MMON background process at the start of the maintenance window.
　　E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
　　Answer: B, C, D
　　ABP相当于自动任务与调度程序之间的中介，其主要作用是将自动任务转换成Autotask作业，供调度程序执行。同样重要的是，ABP还维护所有任务执 行的历史记录。ABP将其专用资料档案库存储在sysaux表空间中，您可以通过DBA_AUTOTASK_TASK 查案该资料档案库。
　　ABP是在启动维护窗口时，由MMON 启动，所有实例只需要一个ABP。MMON进程将监视ABP，并在必要时重启ABP.
　　ABP可以确定为每项维护任务创建的作业列表，此列表按以下优先级排序：紧急、高级、中级。在每个优先级组中，作业是按执行的首选顺序排列的。
　　ABP按照以下方式创建作业：先创建所有紧急优先级的作业，然后创建高优先级的作业，最后创建所有中优先级的作业。
　　ABP将作业分配到多个调度程序作业类。这些作业类将作业映射到基于优先级的使用者组。
　　注意：使用Oracle DB 11g时，不存在与特定任务永久关联的作业。因此，不能使用DBMS_SCHEDULER过程来控制自动任务的行为，请改而使用DBMS_AUTO_TASK_ADMIN过程
　　122.Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)
　　A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
　　B. The problem key is the same as the incident number.
　　C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
　　D. Every problem has a problem key, which is a text string that describes the problem.
　　E. The database makes an entry into the alert log file when problems and incidents occur.
　　Answer: B, C, D
　　A problem is a critical error in the database. Critical errors manifest as internal errors, such as ORA-00600, and other severe errors, such as ORA-07445 (operating system exception) or ORA-04031 (out of memory in the shared pool portion). Problems are tracked in the Automatic Diagnostic Repository (ADR). The ADR is a file-based repository for storing diagnostic data. Because this repository is stored outside the database, the diagnostic data is available even when the database is down. As of Release 11g, the alert log, all trace and dump files, and other diagnostic data are also stored in the ADR.
　　Each problem has a problem key, which is a text string that describes the problem. The problem key includes the error code (such as ORA 600), and in some cases, one or more error parameter values or other information.
　　An incident is a single occurrence of a problem. When a problem occurs multiple times, an incident is created for each occurrence. Incidents are timestamped and tracked in the Automatic Diagnostic Repository (ADR).
　　130.Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
　　A. Undo retention guarantee for the database must be configured.
　　B. Supplemental log must be enabled for the primary key.
　　C. Supplemental log must be enabled.
　　D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
　　Answer: B, C, D
　　No undo retention guarantee is neccessary, flashback log is what it is nedeeded.
　　132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?
　　A. parallel image copy backup
　　B. backup with MAXPIECESIZE configured for the channel
　　C. parallel backup with MAXPIECESIZE configured for the channe
　　D. intrafile parallel backup
　　Answer: D
　　RMAN 的新增功能
　　对超大型文件应用Intrafile  并行备份和还原
　　在备份单一大型数据文件时，现在可以使用多个并行服务器进程和“通道”来有效地分配工作量。这种使用多个部分的方法改善了备份的性能。
　　133.You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)
　　A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
　　B. The KEEP option overrides the configured retention policy.
　　C. The backup contains only data files and archived redo log files.
　　D. The KEEP option is an attribute of an individual backup piece.
　　Answer: A, B
　　134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:
　　RMAN>BACKUP
　　SECTION SIZE 300M
　　TABLESPACE users;
　　What configuration should be effected to accomplish faster and optimized backups by using the above
　　command?
　　A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
　　B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
　　C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
　　D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.
　　Answer: D
　　因为早期版本无法还原多部分备份，所以必须至少将COMPATIBLE设置为11.0。
　　135.The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?
　　A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
　　B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
　　C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
　　D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
　　Answer: A
　　136.You issued the following command to mount the DATA disk group in restricted mode:
　　ALTER DISKGROUP data MOUNT RESTRICT;
　　What is the implication of this command?
　　A. The client RDBMS instance can access the file as a read-only file.
　　B. A new disk cannot be added to a disk group.
　　C. A disk in a disk group can be taken offline.
　　D. The client RDBMS instance cannot access the files in the disk group.
　　Answer: D
　　137.Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:
　　1) Preprocess the captured workload.
　　2) Restart the database in RESTRICTED mode.
　　3) Set up the Replay Clients.
　　4) Restore the test database to the point when the capture started.
　　5) Remap connections.
　　Arrange the steps required in the correct sequence to accomplish this task on the test machine.
　　A. 1, 4, 5, 3 (2 is not required.)
　　B. 1, 4, 3, 5 (2 is not required.)
　　C. 1, 2, 4, 5 (3 is not required.)
　　D. 2, 1, 5, 3, 4
　　E. 1, 2, 4, 5, 3
　　Answer: A
　　142.In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?
　　(Choose all that apply.)
　　A. when one or more file directory paths are accidentally deleted from an ASM disk group
　　B. when one of the disks in a disk group is accidentaly unplugged
　　C. when the data file on an ASM disk group gets corrupted
　　D. when one or more disks in an ASM disk group are lost
　　Answer:  A, D
　　143.Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
　　A. Database must be running in archivelog mode.
　　B. Automatic undo management must be enabled.
　　C. Undo retention guarantee must be enabled.
　　D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
　　Answer: B, D
　　144.In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the
　　initialization parameter file. You issued the following command:
　　SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt)
　　FROM sales
　　GROUP BY sale_category;
　　Where would the result of this query be stored?
　　A. database buffer cache
　　B. shared pool
　　C. PGA
　　D. large pool
　　Answer: B
　　database buffer cache
The portion of the system global area (SGA) that holds copies of data blocks. All client processes concurrently connected to the instance share access to the buffer cache.
shared pool
Portion of the SGA that contains shared memory constructs such as shared SQL areas.
PGA
Program global area. A memory buffer that contains data and control information for a server process.
large pool
Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
　　147.You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)
　　A. The audit trail is stored in an operating system file.
　　B. Auditing is disabled for all privileges.
　　C. The audit trail is stored in the database.
　　D. Auditing is enabled for all privileges.
　　E. Auditing is enabled for certain privileges related to database security.
　　Answer: C, E
　　参考：http://blog.iyunv.com/rlhua/article/details/12292365

如果数据库是使用Database Configuration Assistant (DBCA) 创建的，默认情况下，audit_trail参数设置为DB。
当AUDIT_TRAIL设置为DB时，默认的行为是将审计线索记录到数据库的AUD$表中。（C正确）
默认审计
在Oracle Database 11g中启用审计时，将默认审计那些对安全性非常重要的特定权限和语句。（E正确）　　148.Which dependent object will get invalidated even if it is not affected by the table edefinition?
　　A. packages
　　B. triggers
　　C. synonyms
　　D. views
　　Answer: B
　　151.Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)
　　A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if
　　MEMORY_MAX_TARGET is set to a value greater than zero
　　B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
　　C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
　　D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
　　Answer: A, B, C
　　152.You are performing incomplete recovery using RMAN. You execute the following RUN block:
　　RUN
　　{
　　SET UNTIL SCN 1107600;
　　RESTORE DATABASE;
　　RECOVER DATABASE;
　　}
　　Which statement is true about the result?
　　A.RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
　　B.RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
　　C.RMAN restores all datafiles and control files from the most recent backup
　　D.The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command
　　Answer: B
　　153.You are managing an ASM instance. You previously issued the following statements:
　　ALTER DISKGROUP dg1 DROP DISK disk2;
　　ALTER DISKGROUP dg1 DROP DISK disk3;
　　ALTER DISKGROUP dg1 DROP DISK disk5;
　　You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you
　　issue?
　　A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
　　B. ALTER DISKGROUP dg1 UNDROP;
　　C. ALTER DISKGROUP dg1 UNDROP DISKS;
　　D. You cannot cancel the pending disk drops.
　　Answer： C
　　157.The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be
　　performed?
　　A. The Oracle database will perform block checking for the index blocks only
　　B. The Oracle database will not perform block checking for any of the data blocks
　　C. The Oracle database will perform block checking for the default permanent tablespace only
　　D. The Oracle database will perform block checking for the data blocks in all user tablespaces
　　E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
　　Answer： E
　　161.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups.
　　Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)
　　A. Reregistering the target database in recovery catalog
　　B. Transporting the new tablespaces to the recovery catalog database
　　C. Syncronizing the recovery catalog with the target database control file
　　D. Performing a fresh backup of the target database to include the new data files in the catalog database
　　Answer: C, D
　　163.View the Exhibit to observe the error.

　　You receive this error regularly and have to shut down the database instance to overcome the error. What
　　can the solution be to reduce the chance of this error in future, when implemented?
　　A. setting the PRE_PAGE_SGA parameter to TRUE
　　B. locking the SGA in memory
　　C. increasing the value of SGA_MAX_SIZE
　　D. automatic memory management
　　Answer： D
　　165.View the Exhibit exhibit1.


　　In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of
　　COUNTRY_ID is "US."
　　View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?
　　A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
　　B. Set the STATISTICS_LEVEL parameter to TYPICAL.
　　C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.
　　D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
　　Answer: C
　　166.Exhibit:

　　View the Exhibit and examine the output.
　　You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
　　ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
　　What is the outcome of this command?
　　A. The Flashback Archive is created on the same tablespace where the tables are stored.
　　B. The Flashback Archive is created on the SYSAUX tablespace.
　　C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.
　　D. The table uses the default Flashback Archive.
　　Answer: C
　　170.ASM supports all but which of the following file types? (Choose all that apply.)
　　A. Database files
　　B. Spfiles
　　C. Redo-log files
　　D. Archived log files
　　E. RMAN backup sets
　　F. Password files
　　G. init.ora files
　　Answer: F, G
　　173.Which of the following is not a configurable attribute for an individual disk group?
　　A. AU_SIZE
　　B. COMPATIBLE.RDBMS
　　C. COMPATIBLE.ASM
　　D. DISK_REPAIR_TIME
　　E. DG_DROP_TIME
　　Answer: E
　　175.You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as
　　shown here:
　　Put the tablespaces in backup mode.
　　Back up the datafiles for all tablespaces.
　　Take the tablespaces out of backup mode.
　　Back up all archived redo logs.
　　Your colleague asks for you to comment on his plan. Which response would be correct?
　　A. The plan will work as is.
　　B. The plan needs to be modified to allow for an archive-log switch after step 3.
　　C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
　　D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after
　　step 2.
　　E. The plan cannot work as presented.
　　Answer: B
　　答案解析：
　　个人觉得这道题有问题，在非归档模式下，不能将表空间启动到备份模式，不能在切换日志时将日志归档等，错误如下,应该选E？
　　sys@TEST1107> startup mount
　　ORACLE instance started.
　　Total System Global Area 1269366784 bytes
　　Fixed Size                  2227984 bytes
　　Variable Size             872415472 bytes
　　Database Buffers          385875968 bytes
　　Redo Buffers                8847360 bytes
　　Database mounted.
　　sys@TEST1107> alter database noarchivelog;
　　Database altered.
　　sys@TEST1107> alter database open;
　　Database altered.
　　sys@TEST1107> alter tablespace users begin backup;
　　alter tablespace users begin backup
　　*
　　ERROR at line 1:
　　ORA-01123: cannot start online backup; media recovery not enabled
　　182.Which of the following files cannot be backed up by RMAN? (Choose all that apply.)
　　A. Database datafiles
　　B. Control files
　　C. Online redo logs
　　D. Database pfiles
　　E. Archived redo logs
　　Answer: C, D
　　185.A shoot-out has erupted between your MS development teams using .NET and your Linux
　　development teams using Java. Knowing that your database is in danger, which command would you use
　　to back up your NOARCHIVELOG mode database using RMAN with compression?
　　A. backup database all
　　B. backup compressed database
　　C. backup as compressed backupset database;
　　D. backup as compressed backup database plus archivelog all;
　　E. backup as compressed backupset database plus compress archivelog all;
　　Answer: C
Making Compressed Backups
　　For any use of the BACKUP command that creates backup sets, you can take advantage of RMAN support for binary compression of backup sets. Specify theAS COMPRESSED BACKUPSET option to the BACKUP command.
　　RMAN compresses the backup set contents before writing them to disk. The details of which binary compression level is used are automatically recorded in the backup set. There is no need to explicitly mention the type of compression used or how to decompress the backup set in the recovery operation.
　　Example 9-7 backs up the entire database and archived logs to the configured default backup destination (disk or tape), producing compressed backup sets.

　　Example 9-7 Making Compressed Backups


BACKUP
  AS COMPRESSED BACKUPSET
  DATABASE PLUS ARCHIVELOG;　　Binary compression creates some performance overhead during backup and restore operations. Binary compression consumes CPU resources, so compressed backups should not be scheduled when CPU usage is high. However, the following circumstances may warrant paying the performance penalty:

• 　　You are using disk-based backups when disk space in your fast recovery area or other disk-based backup destination is limited.
  
• 　　You are performing your backups to some device over a network when reduced network bandwidth is more important than CPU usage.
  
• 　　You are using some archival backup media such as CD or DVD, where reducing backup sizes saves on media costs and archival storage.
  

　　186.What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
　　A. Make backups faster
　　B. Store RMAN metadata
　　C. Store RMAN scripts
　　D. Provide the ability to do centralized backup reporting.
　　E. Make recovery faster
　　Answer: B, C, D
　　189.What RMAN command must you use before you can back up a database using the recovery catalog?
　　A. create catalog
　　B. install database
　　C. catalog database
　　D. merge Catalog with database
　　E. register database
　　Answer: E
　　190.You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive
　　the following error message:
　　SQL> startup ORA-01078: failure in processing system parameters LRM-00109:
　　could not open parameter file ,,
　　C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN,
　　how would you respond to this error?
　　A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
　　B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
　　C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
　　D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
　　E. Issue the restore spfile from autobackup command from the RMAN prompt.
　　Answer: C
　　191.While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?
　　A. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 06:30:00'); alter database open;
　　B. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 06:30:00'); alter database open resetlogs;
　　C. restore database until time '06-SEP-2008 18:29:55'); recover database until time '06-SEP-2008 18:29:55'); alter database open resetlogs;
　　D. restore database until time '06-SEP-2008 18:29:55'); alter database open resetlogs;
　　E. restore database until time '06-SEP-2008 18:29:55'); recover database; alter database open resetlogs;
　　Answer: C
　　192.What is the purpose of the until change option of the restore command?
　　A. It allows you to select the SCN that you want to restore to.
　　B. It allows you to select the log sequence number you want to restore to.
　　C. It allows you to select the timestamp you want to restore to.
　　D. It allows you to manually stop the restore at any time as online redo logs are applied.
　　E. None of the above.
　　Answer: A
　　193.What is the purpose of the recover command? (Choose all that apply.)
　　A. Recover database datafiles from physical disk backup sets.
　　B. Recover required incremental backups from physical disk backup sets.
　　C. Recover required archived redo logs from physical disk backup sets.
　　D. Apply incremental backups to recover the database.
　　E. Apply archived redo logs to recover the database.
　　Answer: B, C, D, E
　　Pay attention to incremental backups and archived redo logs.
　　196.What is the purpose of the catalog command?
　　A. To review RMAN control file and recovery catalog metadata and ensure that its correct
　　B. To delete RMAN backup-related metadata from the recovery catalog
　　C. To create metadata in the control file and the recovery catalog related to backup set pieces
　　D. To create a report that lists database backups
　　E. To rebuild the recovery catalog
　　Answer: C
　　198.What are the two different types of database duplication? (Choose two.)
　　A. Active
　　B. Passive
　　C. Online
　　D. Backup-based
　　E. Failure driven
　　Answer: A, D