Your test database is configured to run in NOARCHIVELOG mode

题目
单选题
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file()
A

Take the USERS tablespace offline and re-create the lost data file.

B

Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.

C

Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.

D

Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.

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

第1题:

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()

  • A、The database is in NOMOUNT state.
  • B、The database is in ARCHIVELOG mode and the tablespace is online.
  • C、The database is in ARCHIVELOG mode and the tablespace is offline.
  • D、The database is in NOARCHIVELOG mode and the tablespace is online.
  • E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第2题:

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()

  • A、Hot backup
  • B、Online backup
  • C、consistent backup
  • D、incremental backup
  • E、inconsistent backup

正确答案:C

第3题:

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案:B, C

第4题:

Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()

  • A、ARCHIVELOG mode.
  • B、NOARCHIVELOG mode.
  • C、Open database backups.
  • D、Consistent whole backups.

正确答案:A,C

第5题:

you can perform an active database duplication when the database is in NOARCHIVELOG mode.()

  • A、 True
  • B、 False

正确答案:B

第6题:

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()

  • A、 MMON
  • B、 LGWR
  • C、 ARCH
  • D、 ARWR
  • E、 COPY

正确答案:C

第7题:

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

第8题:

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()

A. The source database backup must be copied over the net for test database.

B. The source database must be run in ARCHIVELOG mode if the database is open.

C. The source database must be shut down cleanly if the database is in mounted state.

D. A net service name should be set up and a listener configured with the target as well as the source database.


参考答案:B, C, D

第9题:

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

第10题:

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

  • A、 backup database all
  • B、 backup compressed database
  • C、 backup as compressed backupset database
  • D、 backup as compressed backup database plus archivelog all
  • E、 backup as compressed backupset database plus compress archivelog all

正确答案:C

更多相关问题