Exit 1Z0-873 MySQL 5.0 Database Administrator Certified Professional Exam, Part I
Question 3 of 5
0% complete
Q3 Multiple choice

Which of the following are true with regards to the server SQL mode?

Select all that apply.

  • A

    The server SQL mode determines how the server should behave when performing data validation checks and interpreting different forms of syntax.

  • B

    The server SQL mode determines whether the server should be read-only or accept commands such
    as INSERT, UPDATE, etc.

  • C

    The default SQL mode can be set by adding a mode="" to the [mysqld] section of a server option file.

  • D

    The SQL mode can be changed at the session level with a SET SESSION sql_mode="" command.