ITPub博客

177-Q31: After you unregister a database from a recovery catalog, what happens to backup metadata in the recovery catalog?A. You must migrate the backup metadata from the recovery catalog to the control file before unregistering the database from the recovery catalog.B. The backup metadat...

177-Q30: Identify the advantage of recovery an image copy of a datafile during RMAN backup.(Choose all thar apply.)A. During media recovery, fewer incremental updates need to be applied to the last image copy.B. The overhead for the block change tracking file is minimal.C. You do not ...

 177-Q28:You are using TISPITR to recover one or more tablespaces to a previous time in point or back to a specific SCN. What included in the recovery set?(Choose all that apply.)A. A copy of the SYSTEM tablespaceB. A copy of the SYSAUX tablespaceC. A copy of the UNDO tablesp...

177-Q27: You are using the RMAN Data Recovery Advisor functionality. When an error occurs, which of the following commands can you use to monitor and maintain failures?(Choose all that apply.)A. IDENTIFY FAILUREB. REPAIR FAILUREC. CHANGE FAILURED. ADVISE FAILUREE. RESET FAILUR...

177-Q18: You configure AUTOBACKUP to ON in an RMAN session. When will RMAN back up the control file?(Choose all that apply.)A. When you run an RMAN BACKUP commandB. When you run an RMAN ALLOCATE commandC. When you add or drop a table in the SYSTEM tablespaceD. When you change the ...

177-Q16: You want to use Flashback Transaction Query to identify the SQL needed to reserse a transaction in the HR.EMPLOYEES table. Where can you find out the value of the transaction ID column XID to use when you query FLASHBACK_TRANSACTION_QUERY?(Choose the best answer.)A. From the VERSIONS...

 177-Q15:To enable remote connections to the database using the password file, what values should REMOTR_LOGIN_PASSWORDFILE have?(Choose all that apply.)A. NONEB. SHAREDC. EXCLUSIVED. REMOTEAnswer: B C参考：http://docs.oracle.com/cd/B28359_01/server.111/b28320/ini...

177-Q14: Which of the following commands successfully allocates a channel?(Choose all that apply.)A. ALLOCATE CHANNEL T2 TYPE TAPE;B. ALLOCATE CHANNEL T2 TYPE SBT_TAPE;C. ALLOCATE CHANNEL DB2 TYPE DISK PARMS='SBT_LIBRARY=MMV.so';D. ALLOCATE CHANNEL T1 TYPE DISK;Answer: B D...

177-Q13: Which of the following methods can you use to run a job chain?(Choose all that apply.)A. Create and schedule a job with CREATE JOB of type CHAIN.B. Create and schedule a chain using the CREATE_CHAIN procedure.C. Create and schedule a chain using the CREATE_JOB_CHAIN procedure...

177-Q122: Which data dictionary views will display information about the current user's recycle bin? Each correct answer represents a complete solution.(Choose all that apply)A. RECYCLEBINB. DBA_RECYCLEBINC. USER_RECYCLEBIND. RECYCLE_BINAnswer: A C哪些数据字典视图将显示当...

177-Q99: Which of the following statements about Automatic Storage Management are true? Each correct answer represents a complete solution.(Choose all that apply)A. It is designed to release the burden of disk and storage management.B. It is a simple storage management interface available...

177-Q84: Your RMAN configuration has the backup optimization set to ON. Which of the following commands will this setting affect? Each correct answer represents a complete solution.(Choose all thar apply)A. BACKUP ARCHIVELOG with ALL or LIKE options.B. BACKUP BACKUPSET ALLC. BACKUP TA...

177-Q67: You need to perform user-managed complete database recovery. What information do you need to retrieve from V$RECOVERY_LOG? (Choose the best answer)A. The history of the datafiles recovered so far.B. The archived redo log files required for recovery.C. The datafiles and archiv...

177-Q48: You lose all control file copies and your datafiles are intact, but your online log files are unavailable. How do you recover the database in this situation?A. Re-create the control file and open the database with RESETLOGS.B. Restore a backup copy of the control file, perform in...

177-Q44: which of the following can be a performance bottlenect in RMAN? (Choose all that apply)A. Reading dataB. Writing dataC. Allocating channelsD. Copying blocksE. Multiplexing BackupsAnswer: A B D在RMAN中，下列哪个可以成为性能瓶颈？...

177-Q40: Which of the following statements is true regarding lightweight jobs? (Choose all that apply)A. You can use EM to create lightweight job.B. A lightweight job generates minimun redo when it run.C. A lightweight job is stored in the same table as other jobs.D. You use the C...

177-Q29: You are using a recovery catalog and you lose all copies of your control file. Which of the following sets commands will you use to restore the control file before you recover the database?A. SET DBID 188390190; RESTORE CONTROLFILE;B. SET DBID 188390190; RESTORE CONTROLFILE FROM ...

177-Q12: Which of the following tablespaces can be recovered while the database is online?(Choose all thar apply.)A. USERSB. UNDOC. SYSAUXD. SYSTEME. EXAMPLEAnswer: A C E

177-Q11: Which of the following methods can you use to enable duplexed RMAN backups?(Choose two answers.)A. Use the initialization parameter RMAN_BACKUP_COPIES.B. Use the BACKUP COPIES option in the RMAN CONFIGURE command.C. Use the BACKUP COPIES option in the ALLOCATE CHANNEL command...

177-Q9 You want to leverage resource consumer groups when using the Scheduler. Which Scheduler object uses resource plans directly?A. A lightweight jobB. A job classC. A job chainD. A programAnswer: B题意是：当使用调度程序时，您想利用资源消耗组。哪个调度对象直接使用资源计...