CMS专题

单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization param

题目
单选题
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario?()
A

 If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.

B

 If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.

C

 If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.

D

 If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()

  • A、archival
  • B、log writer
  • C、database writer
  • D、system monitor
  • E、process monitor
  • F、change tracking writer

正确答案:A,B,C

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

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

第4题:

Which two database operations can be performed at the MOUNT stage of database startup?()

  • A、renaming of data files
  • B、dropping the database user
  • C、renaming of control files
  • D、multiplexing of control files
  • E、configuring the database in ARCHIVELOG mode

正确答案:A,E

第5题:

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

  • A、The backups would be consistent.
  • B、The backups would be inconsistent.
  • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
  • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
  • E、The backups need to be restored and the database has to be recovered in case of a media failure

正确答案:B,C,E

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

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

第8题:

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

第9题:

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()

  • A、The backup will consist of used data blocks only.
  • B、The database must be shut down to accomplish the backup.
  • C、The backup can be accomplished without shutting down the database.
  • D、The backup will contain all database files that have never been backed up.

正确答案:B

第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

更多相关问题