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

Your database is running in ARCHIVELOG mode. One of the data

题目
多选题
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
A

Redo logs

B

Control file

C

The latest backup of only the damaged data file

D

The latest backup of all the data file in the USERS tablespace

E

Temporary files of temporary tablespace

F

Archive Logs since the latest backup to point of failure

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

第1题：

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

第2题：

In order to perform Flashback Transaction Query operations， which of these steps are required？（）

  • A、 Ensure that database is running with version 10.1 compatibility.
  • B、 Enable Flashback Logging.
  • C、 Enable Supplemental Logging.
  • D、 Ensure that the database is running with version 10.0 compatibility.
  • E、 Ensure that the database is in ARCHIVELOG mode.

正确答案:C,D

第3题：

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure


参考答案：A, C, F

第4题：

多选题
In order to perform Flashback Transaction Query operations， which of these steps are required？（）
A

Ensure that database is running with version 10.1 compatibility.

B

Enable Flashback Logging.

C

Enable Supplemental Logging.

D

Ensure that the database is running with version 10.0 compatibility.

E

Ensure that the database is in ARCHIVELOG mode.


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

第5题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

  • A、Data files that belong to only the root container
  • B、Data files that belong to the root container and all the pluggable databases (PDBs)
  • C、Data files that belong to only the root container and PDB$SEED
  • D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

正确答案:B

第6题：

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

第7题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

  • A、 redo logs
  • B、 control file
  • C、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第8题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


参考答案：B

第9题：

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

  • A、only the control file, the current SPFILE, and data files
  • B、only the current SPFILE and data files if autobackup is disabled
  • C、only the data files and the archived redo logs
  • D、the control file, current SPFILE file, data files, and archived redo logs

正确答案:D

第10题：

单选题
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
A

 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B

 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

C

 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

D

 If you restart the database，the database will not be opened.


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

更多相关问题
相关内容