网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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.()
考题
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？（）A
LOSTB
INVALIDC
EXPIREDD
DELETEDE
CORRUPTF
UNKNOWNG
OBSOLETE
考题
单选题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？（）A
Database ControlB
Management ServerC
Management RepositoryD
Application Server ControlE
Oracle Management Agent
考题
单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A
MTTR Advisor would be disabled.B
Redo Log Advisor would be disabled.C
Automatic tuning of checkpoint would be disabled.D
Checkpoint 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？（）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 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？（）A
recover using Oracle Flashback Database technologyB
restore the data files from backup and perform a complete recoveryC
restore only the corrupted data file and perform tablespace recoveryD
restore the data files from backup and perform cancelbased recoveryE
restore 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?（）A
backup database plus archivelogB
backup database plus archivlog until time ‘10:00‘C
backup database plus archivelog timeout ‘10:00‘D
backup 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？（）A
Recreate the database from the staging server.B
Restore a database backup.C
Reload the data using Mass Loader.D
Republish the store archive.E
Republish 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？（）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 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
考题
单选题Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）A
make redo log files smallerB
increase the size of the checkpoint fileC
make the changes as per the advice given by MTTR AdvisorD
make 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？（）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
考题
问答题翻译：We would appreciate your letting us know what discount you can grant if we give you a long-term regular order.
热门标签
最新试卷
