Q. Any client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients.

View solution

Q. How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

View solution

Q. Which mode tells the server to recognize double quote as an identifier quoting character?

View solution

Q. Which mode tells the server to recognize || as the string concatenation operator?

View solution

Q. Which of these modes is a composite server mode?

View solution

Q. MySQL server mode values are case sensitive.

View solution

Q. Which of the following commands sets the SQL mode as TRADITIONAL?

View solution

Q. Which statement can be used to specify the sql_mode system variable at runtime?

View solution

Q. Which of the following characters is illegal in naming an unquoted identifier in SQL?

View solution

Q. In MySQL, identifier names can start with a digit.

View solution

Q. How are identifiers quoted in MySQL?

View solution

Q. Which of the following is an illegal unquoted identifier name?

View solution

Q. Which server mode value enables use of double quotes to wrap identifier names?

View solution

Q. Which server mode value disables use of built in function names as identifiers?

View solution

Q. What is the maximum length for alias names in terms of characters?

View solution

Q. What does a fully qualified table name consist of?

View solution

Q. If no database has been selected, specifying a database qualifier is necessary.

View solution

Q. Which of the following MySQL statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?

View solution

Q. Case sensitivity in SQL statements does not vary for different operating systems of the machine on which the server is running.

View solution

Q. The default case sensitivity of database and table names depends on ___________

View solution