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

Q. Which of the following is case sensitive?

View solution

Q. Which variable is used to set table alias names as non-case sensitive?

View solution

Q. Which case does InnoDB store database names in?

View solution

Q. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

View solution

Q. Which of the following is case sensitive in MySQL?

View solution

Q. Which property determines whether a database object is a case sensitive?

View solution

Q. What is AI in terms of database collation?

View solution

Q. What is the maximum collations a character set can have?

View solution

Q. Unicode support is provided in MySQL.

View solution

Q. Which clause can be used to sort string values according to a specific collation?

View solution

Q. Which MySQL statement is used to find out which character sets are available?

View solution

Q. Which statement is used to show the server’s current character set and collation settings?

View solution