违法和不良信息举报 联系客服
免费注册 登录

Your database is configured in NOARCHIVELOG mode. Due to a m

题目
单选题
Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
A

 Restore all the datafiles from the backup.

B

 Restore only the lost datafile from the backup.

C

 Restore all the datafiles for the lost tablespace from the backup.

D

 Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

  • A、 Enable flashback logging.
  • B、 Start the database in the ARCHIVELOG mode.
  • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
  • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

正确答案:A

第2题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

  • A、adding a new user to the database
  • B、dropping a user from the database
  • C、dropping a table from the database
  • D、dropping a data file from a tablespace
  • E、adding a new tablespace to the database

正确答案:D,E

第3题：

You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

  • A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
  • B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

正确答案:A

第4题：

单选题
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
A

 Enable the flash recovery area and specify it as the archived redo log destination.

B

 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

C

 Enable the flash recovery area but do not specify it as the archived redo log destination. 

D

 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


正确答案： B
解析： 暂无解析

第5题：

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）

  • A、The instance aborts.
  • B、The database cannot be recovered.
  • C、The database can be recovered by restoring the control files from the backup.
  • D、The database remains opened and you have to shut it down with the ABORT option.
  • E、The database can be restored till the point of the last closed whole database backup.

正确答案:A,E

第6题：

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

正确答案:E

第7题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

  • A、 True
  • B、 False

正确答案:B

第8题：

Your boss at Supportcenter.cn 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.

正确答案:E

第9题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

  • A、 Yes， if the database is in ARCHIVELOG mode
  • B、 Yes， if the database is in NOARCHIVELOG mode
  • C、 No， the backup is not usable in any way
  • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

正确答案:C

第10题：

单选题
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


正确答案： E
解析： 暂无解析

更多相关问题
相关内容