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题:
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()
第2题:
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()
第3题:
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?()
第4题:
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.()
第5题:
You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1:Shut down the instance. 2:Execute the ALTER DATABASE ARCHIVELOG command. 3:Start up the instance and mount the database. 4:Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5: Open the database. Which is the correct sequence of steps for accomplishing the task()
第6题:
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?()
第7题:
They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
They are created only in the Fast Recovery Area.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
第8题:
Enable flashback logging.
Start the database in the ARCHIVELOG mode.
Issue the ALTER DATABASE FLASHBACK ON; command.
Set the FAST_START_MTTR_TARGET initialization parameter.
第9题:
The online redo log file Is not allowed to be overwritten.
The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
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.
第10题:
The MANDATORY location must be a flash recovery area.
The optional destinations may not use the flash recovery area.
This setting is not allowed because the first destination is not set as MANDATORY.
The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
第11题:
The archived redo logs are stored in an operating system-dependent location.
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
第12题:
All archived redo log files backed up at least twice to tape are deleted.
All archived redo log files backed up at least once to tape are eligible for deletion.
All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
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.
第13题:
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?()
第14题:
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
第15题:
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?()
第16题:
In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this? ()
第17题:
You want to set the following Initialization parameters for your database Instance LOG_ARCHIVE_DEBT_1 = ,,LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ,,LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ,,LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ,,LOCATION=/disk3/arch Identify the statement that correctly describes this setting.()
第18题:
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files()
第19题:
Archiving will be disabled because the destination for the redo log files is missing.
The database instance will shut down and the error details will be logged in the alert log file.
Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
第20题:
Archiving will be disabled because the destination for the redo log files is missing.
The database instance will shut down and the error details will be logged in the alert log file.
Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
第21题:
They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
They are created only in the Fast Recovery Area.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
第22题:
4,1,3,2,5
1,3,4,5,2
1,3,2,5;4 not required
4,1,5,2;3 not required
1,3,4,5;2 not required
第23题:
The MANDATORY location must be a flash recovery area.
The optional destinations may not use the flash recovery area.
This setting is not allowed because the first destination is not set as MANDATORY.
The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.