Oracle-MySQL 5 Developer Certified Professional Exam, Part I

When redirecting a file containing SQL statements into the mysql client program, an error occurs as follows: ERROR 1007 (HY000) at line 1: Can't create database 'world'; database exists Which of the following parameters can be given to the mysql client program to make it continue processing the file regardless of any errors?

Having connected to a server with the mysql client program, you want to execute a query. What - 100% Pass Guarantee 21 statement terminator can you use to execute the query?

In mysql, which of the following statements will provide a list of all accessible help topics?

When the following command is entered into the mysql client program, which of the options below describes the parameter '/home/sakila/world.sql'? SOURCE /home/sakila/world.sql

Which of the following mysql startup options will you use to guard against long-running SQL

When issuing a SELECT statement which of the following keywords is used to rename a column?

Assuming a table Country exists with a column Name, which of the following are valid uses of the LIMIT clause?

What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned? SELECT time, action, user FROM log20040101 UNION SELECT time, action, user FROM log20040102

The table Office is defined as follows: What would be the order of the rows if the query is rewritten to: SELECT DISTINCT city FROM Office ORDER BY city

The friends table contains the following data: Assuming a suitable collation, how can you retrieve the names in alphabetical order by last_name then first_name?