ITPub博客

（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备份

（187）RMAN provides more granular catalog security through which feature?A. Virtual private databaseB. Virtual private catalogC. RMAN virtual databaseD. RMAN secure catalogE. Oracle Database Vault答案：（B）解析：不同目标库的catalog被集中放在一起。如果对它们catalog...

（186）What is the purpose of the RMAN recovery catalog?(Choose all that apply.)A. Make backups fasterB. Store RMAN metadataC. Store RMAN scriptsD. Provide the ability to do centralized backup reporting.E. Make recovery faster答案：（B、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 allB. backup...

（184）Which RMAN backup command is used to create the block-change tracking file?A. alter database create block change tracking fileB. alter database enable block change fileC. alter database enable block change tracking using file '/ora01/opt/block_change_tracking.fil'D. alter syste...

（183）Which of the following RMAN structures can data from a datafile span?A.RMAN backup-set pieces spanning backup setsB.RMAN backup-set pieces within a given backup setC.RMAN backupsD.RMAN channelsE.None of the above答案：（B）

（182）Which of the following files cannot be backed up by RMAN?(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs答案：（C、D）

（181）Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours.This is the only backup you have.You have lost all the archived redo logs generated since the previous Monday,but you have archived redo logs available from the previous Sunday and earlier.Y...

（180）Which command is used to open the database after an incomplete recovery?A. alter database openB. alter database open repairlogC. alter database open resetlogsD. alter database open resetlogE. alter database resetlogs open答案：（C）

（179）You have lost datafiles 1 and 3 from your database,and the database has crashed.In what order should you perform the following steps to recover your database?1.Take the datafiles that were lost offline.2.startup mount the database3.Issue the alter database open command.4.Re...

（178）If a log file becomes corrupted, it may cause the database to stall（停止）.How would you correct such a situation?A. Recover the online redo log from backup.B. Delete and re-create the log file.C. Use the alter database clear logfile command to clear the log file.D. Shut d...