log_file_name_convert
convert_log_file_name
file_name_convert_log
redo_log_file_name_convert
logfile_convert_directory
第1题:
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
第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题:
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
第4题:
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?()
第5题:
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()
第6题:
You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()
第7题:
Database Identifier (DBID)
names and location of datafiles
names and location of control files
names and location of online redo log files
第8题:
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.
第9题:
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.
第10题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第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题:
The database performance would be enhanced.
The redo log files would be get filled more frequently.
The overall database performance would be degraded.
The mean time to recover (MTTR) would be increased.
第13题:
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()
第14题:
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?()
第15题:
When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?()
第16题:
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)
第17题:
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
第18题:
LOG_ARCHIVE_DEST was not set in the parameter file.
LOG_ARCHIVE_START was not set in the parameter file.
alter database archivelog; was not executed in MOUNT mode.
LOG_ARCHIVE_MAX processes were not set in the parameter file.
第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题:
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.
第21题:
until SCN
until time
until cancel
using backup control file
第22题:
log_file_name_convert
convert_log_file_name
file_name_convert_log
redo_log_file_name_convert
logfile_convert_directory
第23题:
To indicate the location of the auxiliary-instance online redo logs.
To indicate the location of the target database datafiles.
To indicate the location of the auxiliary-instance control file and online redo logs.
To indicate the location of the auxiliary-instance database datafiles.
This is not a valid parameter when duplicating a database.
第24题:
An error will occur during database startup because the second parameter is not valid.
An error will occur during database startup since you are trying to create archived redo logs in two different locations.
Archived redo logs will be created in two different locations by the ARCH process.
Archived redo logs will be created in two different locations by the LGWR process.
Neither parameter setting is valid, so the database will not start up.