Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which binary log format is safest for replication involving non-deterministic functions?

  1. A STATEMENT
  2. B ROW
  3. C MIXED
  4. D TEXT
Answer

ROW

ROW logs the actual data changes, so functions like NOW() or UUID() replicate correctly. STATEMENT logs the SQL and can diverge between source and replica.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as