网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
CheckPoint的功能是保存和（）
参考答案
更多 “CheckPoint的功能是保存和（）” 相关考题
考题
WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()
A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL
考题
Youareattemptingtoincreasethecheckpointintervalonyourdatabase.Eachofthefollowingchoiceswillaffectthedurationand／orfrequencyofcheckpoints,exceptone.Whichisit?()
A.SizeofredologsB.NumberofdatafilesC.LOG_CHECKPOINT_INTERVALD.LOG_CHECKPOINT_TIMEOUT
考题
如何强制执行日志切换()
A.ALTER SYSTEM CHECKPOINT;B.ALTER SYSTEM CHECKPOINT FORCE;C.ALTER SYSTEM SWITCH LOGFILE;D.ALTER SYSTEM SWITCH LOGFILE FORCE;E.ALTER DATABASE LOG SWITCH;
考题
TPS系统，若用户希望保存当前运行系统的控制组态参数，可以对系统作（）工作。A、AUTO CHECKPOINTB、SAVE CHECKPOINTC、RESTORE CHECKPOINTD、BACKUP CHECKPOINT
考题
TPS系统，若用户希望保存当前运行系统的控制组态参数，则可以对系统作（）工作。A、AUTO CHECKPOINTB、SAVE CHECKPOINTC、RESTORE CHECKPOINTD、BACKUP CHECKPOINT
考题
如何强制执行日志切换（）A、ALTER SYSTEM CHECKPOINT;B、ALTER SYSTEM CHECKPOINT FORCE;C、ALTER SYSTEM SWITCH LOGFILE;D、ALTER SYSTEM SWITCH LOGFILE FORCE;E、ALTER DATABASE LOG SWITCH;
考题
Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）A、The SGA advisor will be disabled.B、The MTTR advisor will be disabled.C、Automatic checkpoint tuning will be disabled.D、Checkpoint information will not be written to the alert log file.
考题
Which two statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
Which statement is true regarding checkpoints and recovery？（）A、A checkpoint defines the highest system change number （SCN）.B、All redo entries higher or at the SCN are known to be written to the data files.C、Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D、The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
考题
What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A、MTTR Advisor would be disabled.B、Redo Log Advisor would be disabled.C、Automatic tuning of checkpoint would be disabled.D、Checkpoint information would not be written to the alert log file.
考题
单选题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?（）A
Size of redo logs B
Number of datafiles C
LOG_CHECKPOINT_INTERVAL D
LOG_CHECKPOINT_TIMEOUT
考题
单选题Which statement is true regarding checkpoints and recovery？（）A
A checkpoint defines the highest system change number （SCN）.B
All redo entries higher or at the SCN are known to be written to the data files.C
Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D
The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
考题
多选题Which two statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
多选题Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）ATARGET_REDO_BLKSBFAST_START_IO_TARGETCLOG_CHECKPOINT_TIMEOUTDRECOVERY_ESTIMATED_IOSELOG_FILE_SIZE_REDO_BLKSFLOG_CHECKPOINT_INTERVAL
考题
单选题Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）A
make redo log files smallerB
increase the size of the checkpoint fileC
make the changes as per the advice given by MTTR AdvisorD
make the changes as per the advice given by Checkpoint Advisor
考题
单选题如何强制执行日志切换（）A
ALTER SYSTEM CHECKPOINT;B
ALTER SYSTEM CHECKPOINT FORCE;C
ALTER SYSTEM SWITCH LOGFILE;D
ALTER SYSTEM SWITCH LOGFILE FORCE;E
ALTER DATABASE LOG SWITCH;
热门标签
最新试卷