单选题Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA b, a, c, d, eB a, c, b, d, fC c, a, b, d, eD c, a, b, d, fE e, a, b, d, c

单选题
Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs
A

 b, a, c, d, e

B

 a, c, b, d, f

C

 c, a, b, d, e

D

 c, a, b, d, f

E

 e, a, b, d, c


参考解析

解析: 暂无解析

相关考题:

In order to prove that you would be a valuable problem solver for the employer, you need to write on your résumé about the details on how you solved a problem and what wanted consequences your solution brought about.()

We are pleased to advise you that we complete the shipment of your order 123.()

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running?()A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid, so would have to be aborted.D、The instance would remain open, but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file

翻译:We would appreciate your letting us know what discount you can grant if we give you a long-term regular order.

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state, but all the background processes will be restarted.

You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover (MTTR) would be increased.

If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()  A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.

You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number (SCN) to which you can flash back your database.

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()A、LOSTB、INVALIDC、EXPIREDD、DELETEDE、CORRUPTF、UNKNOWNG、OBSOLETE

You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number (SCN) to which you can flash back your database

In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member?()A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database, and then add a new member to the groupD、restore all the database files from the backup, and then perform a complete recovery E、restore all the database files from the backup, and then perform an incomplete recovery

Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA、 b, a, c, d, eB、 a, c, b, d, fC、 c, a, b, d, eD、 c, a, b, d, fE、 e, a, b, d, c

单选题One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()ALOSTBINVALIDCEXPIREDDDELETEDECORRUPTFUNKNOWNGOBSOLETE

单选题Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA b, a, c, d, eB a, c, b, d, fC c, a, b, d, eD c, a, b, d, fE e, a, b, d, c

单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()ADatabase ControlBManagement ServerCManagement RepositoryDApplication Server ControlEOracle Management Agent

单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?()AMTTR Advisor would be disabled.BRedo Log Advisor would be disabled.CAutomatic tuning of checkpoint would be disabled.DCheckpoint information would not be written to the alert log file.

单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()AThe instance would hang.BThe instance needs to be shut down.CThe instance would be in the open state.DThe instance would abort in such cases.EThe instance would be in the open and invalid state.FThe instance would in the open state, but all the background processes will be restarted.

单选题You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number (SCN) to which you can flash back your database.

单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()Arecover using Oracle Flashback Database technologyBrestore the data files from backup and perform a complete recoveryCrestore only the corrupted data file and perform tablespace recoveryDrestore the data files from backup and perform cancel­based recoveryErestore the entire database from the most recent backup and start the instance and open the database

单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()Abackup database plus archivelogBbackup database plus archivlog until time ‘10:00‘Cbackup database plus archivelog timeout ‘10:00‘Dbackup database plus archivelog duration 10:00

单选题In the event of a failure, what would be the MOST complete method for recovering the WebSphere Commerce database?()ARecreate the database from the staging server.BRestore a database backup.CReload the data using Mass Loader.DRepublish the store archive.ERepublish from WebSphere Catalog Manager.

单选题You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()AThe database performance would be enhanced.BThe redo log files would be get filled more frequently.CThe overall database performance would be degraded.DThe mean time to recover (MTTR) would be increased.

单选题If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()A Complete database recovery.B Incomplete database recovery.C Approximate database recovery.D Archived database recovery.E The database could not be recovered with RMAN.

单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running?()AThe instance would normally abort.BThe instance would not be affected.CThe instance would be invalid, so would have to be aborted.DThe instance would remain open, but the LGWR process would fail.EThe instance would remain open and would automatically create the missing file

单选题Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?()Amake redo log files smallerBincrease the size of the checkpoint fileCmake the changes as per the advice given by MTTR AdvisorDmake the changes as per the advice given by Checkpoint Advisor

单选题You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number (SCN) to which you can flash back your database

问答题翻译:We would appreciate your letting us know what discount you can grant if we give you a long-term regular order.