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

Your database operates in ARCHIVELOG mode and all the tables

题目
多选题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）
A

open the database with the RESTRICTED option

B

open the database with the RESETLOGS option

C

recover to the required SCN only that data file in which the error occurred

D

recover all the data files to the same system change number （SCN）

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

第1题：

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

第2题：

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

  • A、The destination must be global only.
  • B、A maximum of five destinations can be assigned.
  • C、A maximum of ten different destinations can be assigned.
  • D、All the destinations are determined by the server automatically.
  • E、The destination may be local or remote for a Standby Database.
  • F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

正确答案:C,E

第3题：

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

第4题：

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

第5题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

  • A、Database Datafiles 
  • B、Database Control Files 
  • C、Online redo logs
  • D、Archived redo logs 
  • E、The database SPFILE 
  • F、None of the above, all these files are backed up. 

正确答案:C

第6题：

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

第7题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第8题：

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

第9题：

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

第10题：

Which is the correct command to put the database in ARCHIVELOG mode？（）  

  • A、 alter database archivelog
  • B、 alter system enable archivelog mode
  • C、 alter database enable archive
  • D、 alter database archivelog enable
  • E、 None of the above

正确答案:A

更多相关问题
相关内容