nerdexam
Oracle

1Z0-908 · Question #10

1Z0-908 Question #10: Real Exam Question with Answer & Explanation

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

MySQL Architecture

Question

You made some table definition changes to a schema in your MySQL Server. Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

Options

  • AMySQL writes SDI to the binary log for distributed backups.
  • BMySQL keeps InnoDB metadata changes in .sdi files in datadir.
  • CThe metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
  • DMySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
  • EMySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Unlock 1Z0-908 to see the answer

You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 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

#SDI#InnoDB metadata#table definition#metadata storage
Full 1Z0-908 Practice