ITPub博客

（205）You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters.You restart your database instance.Which statement about the result is true?A.The database instance starts,and Oracle sets the default val...

（204）You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.C. Use compression when performing ...

（203）Which statement about the enabling of table compression in Oracle Database 11g is true?A. Compression can be enabled at the table,tablespace,or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct loadsand conventional DML.C. C...

（202）In which two aspects does hot patching differ from conventional patching?(Choose two.)A. It consumes more memory compared with conventional patching.B. It can be installed and uninstalled via OPatch unlike conventional patching.C. It takes more time to install or uninstall compared...

（201）Examine the following PL/SQL block:SET SERVEROUTPUT ONSET LONG 10000DECLARE  report clob;BEGIN  report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();  DB...

（200）Which operation requires that you create an auxiliary instance manually before executing the operation?(Choose all that apply.)A. Backup-based database duplication.B. Active database duplication.C. Tablespace point-in-time recovery.D. No operation requires the creation of an au...

（199）When you're performing a tablespace point-in-time recovery,which tablespaces will always be restored to the auxiliary instance?(Choose all that apply.)A. The SYSTEM tablespace.B. The UNDO tablespace.C. All tablespaces with tables.D. All tablespaces with indexes.E. No tables...

（198）What are the two different types of database duplication?(Choose two.)A. ActiveB. PassiveC. OnlineD. Backup-basedE. Failure driven答案：（A、D）

（197）Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user;E. report obsolete;答案：（D）解析：RMAN>report user;RMAN-00571:==============================...

（196）What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup...

（195）What is the purpose of the list expired backup command?A. Lists all backups impacted by a resetlogs commandB. Lists all backups that are subject to retention criteriaC. Lists all backups that are missing associated physical backup set piecesD. Lists the status of datafile backu...

（194）What is an obsolete backup set?A. A backup set that is missing one or more backup set piecesB. A backup that has exceeded the retention criteria and is no longer neededC. A backup set that does not include archived redo logsD. A backup set that can not be recovered due to corru...

（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 ...

（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 a...

（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 wa...

（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 R...

（189）What RMAN command must you use before you can back up a database using the recovery catalog?A. create catalogB. install databaseC. catalog databaseD. merge Catalog with databaseE. register database答案：（E）解析：E，需要把目标库在catalog数据库里注册一下...

（188）You can back up the RMAN recovery catalog with RMAN.A. TrueB. False答案：（A）解析：Catalog数据库也可以用rman备份