Size of redo logs
Number of datafiles
LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT
第1题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第2题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第3题:
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined?()
第4题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server? ()
第5题:
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?()
第6题:
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?()
第7题:
V_CONTROLFILE_RECORD_SECTION
V_CONTROLFILE
V$PARAMETER
init.ora file
第8题:
A checkpoint defines the highest system change number (SCN).
All redo entries higher or at the SCN are known to be written to the data files.
Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
第9题:
Disable automatic checkpoint tuning.
Check the size of the redo log file size and increase the size if it is small.
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.
第10题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第11题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第12题:
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.
第13题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
第14题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
第15题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
第16题:
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?()
第17题:
Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?()
第18题:
Which statement is true regarding checkpoints and recovery?()
第19题:
TARGET_REDO_BLKS
FAST_START_IO_TARGET
LOG_CHECKPOINT_TIMEOUT
RECOVERY_ESTIMATED_IOS
LOG_FILE_SIZE_REDO_BLKS
LOG_CHECKPOINT_INTERVAL
第20题:
Shared pool
Control file
SGA
PGA
第21题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第22题:
Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第23题:
Size of redo logs
Number of datafiles
LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT
第24题:
Disable automatic checkpoint tuning.
Check the size of the redo log file size and increase the size if it is small.
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
Decrease the number of redo log members if there are more than one redo log members available in each redo log group.