搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）

A、 You find that one of the redo log members in each redo log group is lost.

B、 You find that a data file that belongs to the USERS tablespace is damaged.

C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.

D、 You find that the current redo log group is damaged and is not available for recovery.

E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.

查看正确答案
更多“Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）”相关的问题
第1题
[单选题] You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files  B、dropping a user in your database  C、enabling or disabling redo log archiving  D、dropping a tablespace in your database  E、re-creating the control files， after you lost all the control files in your database  

点击查看答案
第2题
[单选题] 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.  

点击查看答案
第3题
[单选题] 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.  

点击查看答案
第4题
[单选题] Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

A、 V$DATABASE  B、 V$UNDOSTAT  C、 V$FLASHBACK_DATABASE_LOG  D、 V$FLASHBACK_DATABASE_STAT  

点击查看答案
第5题
[单选题] For which database operation would you need the database to be in the MOUNT state（）

A、renaming the control files  B、re-creating the control files  C、dropping a user in your database  D、dropping a tablespace in your database  E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes  

点击查看答案
第6题
[多选题] Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

A、The database opens normally.  B、The database prompts for a database recovery.  C、The database writer writes to a trace file， indicating that the temporary file is not found.  D、The database gets mounted and throws an error indicating that the temporary file requires recovery.  

点击查看答案
第7题
[单选题] While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

A、configure the database to run in ARCHIVELOG mode  B、configure the Flash Recovery Area to enable automatic database backup  C、schedule the database backup using DBMS_JOB package after creating the database  D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database  E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database  

点击查看答案
第8题
[多选题] Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A、 The database writer writes to a trace file， indicating that the temporary file is not found.  B、 The database prompts for a database recovery.  C、 The database opens normally.  D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.  

点击查看答案
第9题
[] While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

A、A.configure the database to run in ARCHIVELOG mode  B、B.configure the Flash Recovery Area to enable automatic database backup  C、C.schedule the database backup using DBMS_JOB package after creating the database  D、D.schedule the database backup using Recovery Manager （RMAN） commands after creating the database  E、E.schedule the database backup using Database Configuration Assistant （DBCA） while creating the database  

点击查看答案
第10题
[单选题] Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

A、The database is in mount state.  B、One of the tablespaces is offline.  C、One of the tablespaces is read only.  D、The database operates in ARCHIEVELOG mode.  E、The database operates in NOARCHIEVELOG mode.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服