The database is configured in ARCHIVELOG mode and regular co

题目
多选题
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)
A

Control files

B

Password files

C

Inactive online redo log file

D

Archived log files required to perform recovery

E

Newly created tablespace which is not backed up

参考答案和解析
正确答案: D,E
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?()

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.


参考答案:B

第2题:

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

第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 statements are true regarding the database in ARCHIVELOG mode?()

  • A、You have to shut down the database to perform the backups.
  • B、Archiving information is written to the data files and redo log files.
  • C、You can perform complete database backups without closing the database.
  • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
  • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

正确答案:C,E

第5题:

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility?()  

  • A、 The block change tracking feature must be enabled.
  • B、 OMF must be configured on your database.
  • C、 The database must be in ARCHIVELOG mode.
  • D、 A USERID must be supplied.

正确答案:D

第6题:

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)

A. Control files

B. Password files

C. Inactive online redo log file

D. Archived log files required to perform recovery

E. Newly created tablespace which is not backed up


参考答案:A, D

第7题:

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

第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题:

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()

  • A、 Control files
  • B、 Password files
  • C、 Inactive online redo log file
  • D、 Archived log files required to perform recovery
  • E、 Newly created tablespace which is not backed up

正确答案:A,D

第10题:

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area (FRA) for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

更多相关问题