It will be created on the local file system.
It will be created only in the Flash Recovery Area.
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
第1题:
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature? ()
第2题:
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files()
第3题:
You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = ‘LOCATION=/disk1/arch‘LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch‘LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch‘LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY‘Identify the statement that correctly describes this setting.()
A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
第4题:
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?()
第5题:
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
第6题:
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?()
第7题:
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?()
第8题:
ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver:LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles()
A.Itwillbecreatedonthelocalfilesystem.
B.ItwillbecreatedonlyintheFlashRecoveryArea.
C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.
D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.
第9题:
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
第10题:
You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?()