Quiz 1Z0-871

Quiz 1Z0-871, MySQL 5 Developer Certified Professional , Part I

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

Which of the following statements are true?

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 name FROM friends WHERE name LIKE "P_t%"

How many rows will the following query return? SELECT name, telephone FROM user WHERE telephone=”

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

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

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

Which of the following MySQL client programs require a connection to a MySQL server in order to work on database contents?

Which of the following statements can be used to change the name of the column name into firstname?