log01.log
logORCL01.log
1_2.logALTER ROLLBACK SEGMENT
ora_1_asdf1234.log
第1题:
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
第2题:
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? ()
第3题:
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
第4题:
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?()
第5题:
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
第6题:
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()
第7题:
multiplexed control files
RMAN obsolete backups
multiplexed online redo log files
archived redo logs that have not been copied to tape
第8题:
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
第9题:
The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
Before the instance starts, you receive an error about the missing redo log files of a group.
The instance starts and the database opens with an error message written to the alert log file.
The instance starts and the database opens because two redo log groups still exist.
The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
第10题:
ALTER DATABASE
ALTER SYSTEM
ALTER USER
ALTER REDO LOG
第11题:
log01.log
logORCL01.log
1_2.logALTER ROLLBACK SEGMENT
ora_1_asdf1234.log
第12题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第13题:
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()
第14题:
If you create your database using Oracle Managed Files (OMF), what is true?()
第15题:
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()
第16题:
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
第17题:
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?()
第18题:
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()
第19题:
the system change number
the locations of the redo log files
the locations of the datafiles
the physical location of all the database changes
第20题:
Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第21题:
ALTER DATABASE DROP LOGFILE GROUP 1
ALTER DATABASE CLEAR LOGFILE GROUP 1
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
第22题:
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
第23题:
V$LOG
V$LOFHIST
V$LOGFILE
V$LOG_HISTORY
第24题:
You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
You must define directories for two online redo log groups and three copies of the control file.
If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
You must use only OMF data files when adding new tablespaces or data files to your database in the future.