网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Archived redo logs can be copied to more than one destination by Oracle.()

  • A、 True
  • B、 False

参考答案

更多 “Archived redo logs can be copied to more than one destination by Oracle.()A、 TrueB、 False” 相关考题
考题 The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?()A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

考题 Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.) A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

考题 Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

考题 Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

考题 You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.

考题 Which type of database file is spread across all disks in a disk group?()A、 All types of files are spread across all disks in the disk group.B、 DatafilesC、 Redo log filesD、 Archived redo log filesE、 Control files

考题 You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape

考题 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 filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs

考题 What is the purpose of the recover command?() A、 Recover database datafiles from physical disk backup sets.B、 Recover required incremental backups from physical disk backup sets.C、 Recover required archived redo logs from physical disk backup sets.D、 Apply incremental backups to recover the database. E、 Apply archived redo logs to recover the database.

考题 Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?()  A、 backup databaseB、 backup database and archivelogsC、 backup database plus archivelogsD、 backup database plus archivelog delete inputE、 backup database and archivelog delete input

考题 While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?()A、The backup fails because one of the archived redo log files is missing. B、The backup succeeds but it would be without the missing archived log. C、During backup, you are prompted for the alternative destination for the missing archived redo log file. D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 

考题 Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A、Database datafilesB、Control filesC、Online redo logsD、Database pfilesE、Archived redo logs

考题 Which of the following does the recover command not do?()  A、 Restore archived redo logs.B、 Apply archived redo logs.C、 Restore incremental backups.D、 Apply incremental backups.E、 Restore datafile images.

考题 单选题The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’   Examine the following RMAN command issued to set the deletion policy for archived log files:   RMAN CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt; Which statement is true regarding what this command accomplishes?()A  All archived redo log files backed up at least twice to tape are deleted.B  All archived redo log files backed up at least once to tape are eligible for deletion.C  All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D  All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

考题 单选题You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A  The archived redo log files will be overwritten.B  The archived redo log files are deleted automatically.C  The archived redo log files should be moved to some other location.D  The archived redo log files are still maintained because the file names are unique.

考题 单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d:/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database?()A  The archived redo logs are stored in an operating system-dependent location.B  The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C  The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D  The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

考题 单选题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 filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file, current SPFILE file, data files, and archived redo logs

考题 单选题Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?()A  backup databaseB  backup database and archivelogsC  backup database plus archivelogsD  backup database plus archivelog delete inputE  backup database and archivelog delete input

考题 单选题Archived redo logs can be copied to more than one destination by Oracle.()A  TrueB  False

考题 单选题Which components are needed for successful and most efficient recovery.()A  The backup RB3 and the current online redo log filesB  the backup RB2 and the archived redo log files after the log sequence number 15622C  Backup R81 and the archived redo log hies after the log sequence number 12871D  The backup RB3 and the archived redo log files after the log sequence number 16721

考题 单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:   LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional,you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch?()A  The online redo log file Is not allowed to be overwritten.B  The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C  The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D  The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

考题 单选题Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()A  13:00 on Tuesday.B  15:00 on Tuesday.C  Up until the last available archived redo log on Sunday.D  To any point; all the redo should still be available in the online redo logs.E  The database is not recoverable.

考题 单选题You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A  multiplexed control filesB  RMAN obsolete backupsC  multiplexed online redo log filesD  archived redo logs that have not been copied to tape

考题 单选题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 filesB  only the current SPFILE and data files if autobackup is disabledC  only the data files and the archived redo logsD  the control file,current SPFILE file,data files,and archived redo logs

考题 单选题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area?()A  The backup fails because one of the archived redo log files is missing.B  The backup succeeds but it would be without the missing archived log.C  During backup,you are prompted for the alternative destination for the missing archived redo log file.D  The backup succeeds because it fails over to one of the alternative archived redo log destinations.

考题 单选题Which of the following does the recover command not do?()A  Restore archived redo logs.B  Apply archived redo logs.C  Restore incremental backups.D  Apply incremental backups.E  Restore datafile images.

考题 单选题What will be the result of the following configuration?()   Log_archive_dest_1=location=c:/oracle/arch/mydb Log_archive_dest_2=location=z:/oracle/arch/mydbA  An error will occur during database startup because the second parameter is not valid.B  An error will occur during database startup since you are trying to create archived redo logs in two different locations.C  Archived redo logs will be created in two different locations by the ARCH process.D  Archived redo logs will be created in two different locations by the LGWR process.E  Neither parameter setting is valid, so the database will not start up.