Study tips 1Z0-871

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

Is the following statement true or false?

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

How many rows will the following query return?

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%"

what will be the output of the following SQL statement?

Which of the following statements are true?

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

What will be the result of the following SQL statement?

What does the following statement do?