nerdexam
Oracle

1Z0-888 · Question #35

1Z0-888 Question #35: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.

Backup and Recovery

Question

Which two statements describe how InnoDB recovery works?

Options

  • AInnoDB handles most crash recoveries automatically.
  • BInnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
  • CThere will in general be lost committed transactions after a crash using the default settings.
  • DIt is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
  • EIt is recommended to set innodb_force_recovery = 1 as part of normal operations.
  • FIt is always required to enable innodb_force_recovery to perform a crash recovery.

Unlock 1Z0-888 to see the answer

You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#InnoDB recovery#innodb_force_recovery#crash recovery#transaction recovery
Full 1Z0-888 Practice