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

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 259 discussion

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

Which three statements are true about checkpointing? (Choose three.)

  • A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
  • B. It ensures that all dirty buffers are written to data files during consistent shutdown.
  • C. It reduces the time required for recovery in case of an instance failure.
  • D. Frequent thread checkpoints can degrade database performance.
  • E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️
by Clozoerie at Aug. 8, 2021, 6:27 p.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
Oracle2020
Highly Voted 3 years, 10 months ago
It is B,C,D E cannot be because the Database Writer (DBWn) process don't write checkpoint information into data file headers and the control file.
upvoted 6 times
...
Ray520
Most Recent 3 years, 1 month ago
A and E are incorrect. CKPT itslef does not write data to datafiles. CKPT updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk.
upvoted 2 times
...
Clozoerie
3 years, 10 months ago
Answer is CDE
upvoted 1 times
Clozoerie
3 years, 9 months ago
No it is really BCD finally
upvoted 3 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