ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam
Go to Exam

Exam 1z0-063 topic 1 question 183 discussion

Actual exam question from Oracle's 1z0-063
Question #: 183
Topic #: 1
[All 1z0-063 Questions]

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

  • A. The MTTR advisor is enabled only if the value is greater than the default value.
  • B. Automatic checkpoint tuning is enabled.
  • C. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
  • D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected "mean time to recover" (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Note: The default value is 0. Range of values is 0 to 3600 seconds.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058

https://docs.oracle.com/cd/A97630_01/server.920/
a96533/instreco.htm
by AVD at March 3, 2019, 7:01 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
HakuPudding
3 years ago
Please don't bet the answers.. If you think the options you chose are right, give the reason why. Because of the "bet" comments, people are confused. By the way, thank you joe_doe for the reference and giving the reason why the answer is A, C.
upvoted 2 times
...
joe_doe
4 years, 3 months ago
C is definitely a correct answer ，referenced by https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/FAST_START_MTTR_TARGET.html#GUID-D2452F33-0FD8-4297-85EC-FF63A0F03499
upvoted 2 times
...
gracee
4 years, 11 months ago
correct ans AC
upvoted 3 times
...
alipilot2006
5 years, 7 months ago
The answer is correct !
upvoted 2 times
...
AVD
5 years, 9 months ago
Answer should be 'A' and 'B'
upvoted 2 times
Sugar
4 years, 4 months ago
A B is also my bet here
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago