You notice that the performance of the database has degraded because of frequent
checkpoints. Which two actions resolve the issue? (Choose two.)
A.
Check the size of the redo log file size and increase the size if it is small
B.
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR
Advisor
C.
Decrease the number of redo log members if there are more than one redo l og members
available in each redo log group
D.
Disable automatic checkpoint tuning
Questions missing from this exam, in 1Z0-052 (v.3)
1. When would Datapump external tables be used instead of Datapump import direct path?
2. Is the lock from a select … FOR UPDATE compatible with a ROW SHARE table lock?
FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Are these dumps still valid for the exam? Haw anyone passed the exam with those dumps?
Not sure, I am wondering the same thing