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

Your database in running in the ARCHIVELOG mode. You issue t

题目
多选题
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
A

The copy of the datafile created is stored in the RMAN repository.

B

The copy of the datafile created can be viewed using the LIST BACKUP command.

C

The copy of the datafile created using this COPY command can be placed only on the disk.

D

The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

E

The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

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

第1题：

Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

  • A、Until last commit
  • B、Until the time you perform recovery
  • C、Until the time the date file got corrupted
  • D、Until the point where the last transaction begun
  • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

正确答案:A

第2题：

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

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

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第5题：

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

  • A、Until last commit
  • B、Until the time you perform recovery
  • C、Until the time the date file got corrupted
  • D、Until the point where the last transaction begun
  • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

正确答案:A

第6题：

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

第7题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

  • A、You can perform online whole database backups.
  • B、You can performofflinewhole database backups.
  • C、You cannot perform schema-level export/import operations.
  • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

正确答案:B

第8题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

  • A、 the datafiles associated with the SYSTEM tablespace
  • B、 the datafiles associated to the DATA1 tablespace
  • C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
  • D、 all the datafiles in the database

正确答案:D

第9题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

  • A、 Enable flashback logging.
  • B、 Start the database in the ARCHIVELOG mode.
  • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
  • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

正确答案:A

第10题：

Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

  • A、 ALTER DATABASE DROP LOGFILE GROUP 1
  • B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
  • C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
  • D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

正确答案:C

更多相关问题
相关内容