Oracle-MySQL 5 Developer Certified Professional Exam, Part I Set 2

The mysql command is used to start the MySQL database and open the prompt to accept queries.

Is the following statement true or false? If the MySQL server is started with --sql- mode=IGNORE_SPACE, all function names are treated as reserved words

Which of the following queries will return a value of NULL?

The table user has the following structure and contents. mysql> DESCRIBE user; SELECT * FROM user; 'NULL' in the output is the NULL value, not the character string 'NULL'. How many rows will the following query return? SELECT name, telephone FROM user WHERE telephone=''

The friends table has the following data: What will be the result of the following statement: SELECT name FROM friends WHERE name LIKE "P_t%"

The table t has a column c with following contents: mysql> SELECT c FROM t; - 100% Pass Guarantee 16 If c is a CHAR column that has the case-insensitive latin1_swedish_ci collation what will be the output of the following SQL statement? SELECT c, COUNT(*) from t GROUP BY c

Which of the following statements are true?

Which sql-mode option is required for 'abc' || 'def' to be returned as the concatenated string 'abcdef'?

str is a multi-byte character string which contains five two-byte characters. What will be the result of the following SQL statement? SELECT LENGTH(str), CHAR_LENGTH(str)

What does the following statement do? CREATE /*!32302 TEMPORARY */ TABLE t (a INT);