Study tips 1Z0-871

Which of the following SELECT statements are valid?

How many rows will be returned when the following statement is executed? SELECT DISTINCT col1 FROM table1;

What will be the result of the following SELECT?

Assuming a suitable collation, how can you retrieve the names in alphabetical order by last_name then first_name?

SELECT DISTINCT city FROM Office ORDER BY city

What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned?

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

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

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

sql’? SOURCE /home/sakila/world