1Z0-873 Question #69: Real Exam Question with Answer & Explanation

The correct answer is A. The server SQL mode determines how the server should behave when performing data validation D. The SQL mode can be changed at the session level with a SET SESSION sql_mode="". Many operational characteristics of MySQL Server can be configured by setting the SQL mode. This mode consists of optional values that each control some aspect of query processing. By setting the SQL mode appropriately, a client program can instruct the server how strict or forgi

Question

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

Options

AThe server SQL mode determines how the server should behave when performing data validation
BThe server SQL mode determines whether the server should be read-only or accept commands
CThe default SQL mode can be set by adding a mode="" to the [mysqld] section of a server option
DThe SQL mode can be changed at the session level with a SET SESSION sql_mode=""

Explanation

Many operational characteristics of MySQL Server can be configured by setting the SQL mode. This mode consists of optional values that each control some aspect of query processing. By setting the SQL mode appropriately, a client program can instruct the server how strict or forgiving to be about accepting input data, enable or disable behaviors relating to standard SQL conformance, or provide better compatibility with other database systems. The SQL mode is controlled by means of the sql_mode system variable.

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice