多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all t

题目

多选题

The loss of which two types of files may require a recovery with the RESETLOGS option？（）

control files

password file

archived log files

system-critical data files for which all the redo entries are present

non-system-critical data files for which all the redo entries are present

参考答案和解析

正确答案： B,C

解析：暂无解析

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

相似问题和答案

第1题：

Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.

参考答案：B, C

第2题：

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

A、 a list of files that require a backup within three days
B、 a list of files that have not been backed up for three days
C、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D、 a list of files for which a backup has already been performed and may need a backup after three days

正确答案:B

第3题：

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece

参考答案：B, C, E

第4题：

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.

正确答案:A,C

第5题：

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）

A、RMAN image copies
B、RMAN database backups
C、RMAN tablespace backups
D、usermanaged backups placed in the flash recovery area
E、usermanaged backups that have been cataloged with RMAN
F、usermanaged data file backups for which the full path name is specified

正确答案:A,B,C,E

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

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

A、loss of a tempfile
B、loss of a system data file
C、loss of one of the control files
D、loss of one of the tablespaces
E、loss of a member from each redo log group
F、loss of the only member of an unarchived redo log group

正确答案:F

第8题：

Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? ()

A. failures because a data file is renamed by error

B. failures when no standby database is configured

C. failures that require no archive logs to be applied for recovery

D. failures due to loss of connectivity-for example, an unplugged disk cable

参考答案：A, 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题：

Which two are characteristics of user-managed backup and recovery operations？（）

A、Recovery is initiated using SQL*Plus.
B、Database files are backed up using SQL commands.
C、Database files are backed up with Recovery Manager.
D、Database files are restored using Recovery Manager.
E、Database files are backed up using operating system commands.

正确答案:A,B

The loss of which two types of files may require a recovery

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容