The checkpoint frequency decreases with the smaller redo log file size.
It ensures that all committed data is written to the data files during normal shutdown.
The frequent full checkpoint in a database can cause the overall degradation of the database performance.
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
第1题:
Which statements are true about checkpointing()
第2题:
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)
第3题:
Which three statements are true about the stages of database startup?()
第4题:
Which two statements about the background process of the database writer are true()
第5题:
Which two statements about the background process of thedatabase writerare true()
第6题:
Which three statements are true about database recovery operations?()
第7题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第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题:
control files
password file
archived log files
system-critical data files for which all the redo entries are present
non-system-critical data files for which all the redo entries are present
第10题:
The checkpoint frequency decreases with the smaller redo log file size.
It ensures that all committed data is written to the data files during normal shutdown.
The frequent full checkpoint in a database can cause the overall degradation of the database performance.
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the onlineredo log files
第11题:
The KEEP option overrides the configured retention policy
The KEEP option is an attribute of an individual backup piece
The backup contains only data files and archived redo log files
The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
第12题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第13题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
第14题:
Which two statements are true about checkpointing()
第15题:
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()
第16题:
Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?()
第17题:
Which statement is true regarding checkpoints and recovery?()
第18题:
Inactive and current redo log files are required to accomplish recovery.
Online and archived redo log files are required to accomplish instance recovery.
All redo log entries after the last checkpoint are applied from redo log files to data files.
All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
第19题:
The backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.
The KEEP option overrides the configured retention policy.
The backup contains only data files and archived redo log files.
The KEEP option is an attribute of an individual backup piece.
第20题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes
第21题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第22题:
Inactive and current redo log files are required to accomplish recovery.
Online and archived redo log files are required to accomplish instance recovery.
All redo log entries after the last checkpoint are applied from redo log files to data files.
All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
第23题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.