ITPub博客

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

（177）When you create a backup control file, where is the resulting file written to?A. The database user dump destination directoryB. The database diagnostic destination directoryC. To $ORACLE_HOME/rdbmsD. To $ORACLE_HOME/adminE. To the directory and filename you specify in the c...

（176）Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.B. Datafiles are not written to during hot backups.C. Changes to th...

（175）You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database,as shown here:1. Put the tablespaces in backup mode.2. Back up the datafiles for all tablespaces.3. Take the tablespaces out of backup mode.4. Back up all archived redo logs.Your colleague a...

（174）What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?A. MMONB. LGWRC. ARCnD. ARWRE. COPY答案：（C）解析：肯定是归档模式特有的归档进程，ARCn

（173）Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE. DG_DROP_TIME答案：（E）解析：《Automatic Storage Management Administrator's Guide》 4.1磁盘组属性是绑...

（172）What is the net effect of the following command?alter diskgroup dgroup1 drop disk abc;A. The disk ABC will be dropped from the disk group.Since you did not issue a rebalance command,the data on that disk will be lost.B. The command will raise an error indicating that you need to re...

（171）After executing the command：alter diskgroup disk group2 drop disk dg2a;you issue the following command from the ASM instance: Select group_number, count(*) from v$asm_operation;What is the implication if the query against V$ASM_OPERATION returns zero rows?A. The drop disk operatio...

>parameter TYPEVALUE------------------------------------ ----------- ------------------------------log_archive_dest_10                  stri...

（170）ASM supports all but which of the following file types?(Choose all that apply.)A. Database filesB. SpfilesC. Redo-log filesD. Archived log filesE. RMAN backup setsF. Password filesG. init.ora files答案：（F、G）解析：《Automatic Storage Management Admi...