Free 1Z0-071 Restricting and Sorting Data Questions and Answers

Question 1

Which SQL clause is used to filter rows returned by a query based on a specified condition?

Accepted Answer

WHERE

Answer

SELECT

Answer

FROM

Answer

ORDER BY

Question 2

How would you retrieve all rows from a table named employees where the salary is greater than 50000?

Accepted Answer

SELECT * FROM employees WHERE salary > 50000;

Answer

SELECT * FROM employees ORDER BY salary > 50000;

Answer

SELECT * WHERE salary > 50000 FROM employees;

Answer

SELECT * ORDER BY salary > 50000 FROM employees;

Question 3

What does the ORDER BY clause do in a SQL query?

Accepted Answer

Sorts the result set based on one or more columns.

Answer

Filters rows based on a condition.

Answer

Combines rows from multiple tables.

Answer

Limits the number of rows returned by the query.

Question 4

Which SQL statement will return all employees in the employees table sorted by their last_name in ascending order?

Accepted Answer

SELECT * FROM employees ORDER BY last_name ASC;

Answer

SELECT * FROM employees SORT BY last_name;

Answer

SELECT * FROM employees WHERE last_name ORDER BY ASC;

Answer

SELECT * FROM employees WHERE ORDER BY last_name;

Question 5

How can you retrieve only the top 5 highest-paid employees from the employees table?

Accepted Answer

SELECT * FROM employees ORDER BY salary DESC FETCH FIRST 5 ROWS ONLY;

Answer

SELECT * FROM employees WHERE salary DESC LIMIT 5;

Answer

SELECT TOP 5 * FROM employees ORDER BY salary DESC;

Answer

SELECT * FROM employees SORT BY salary LIMIT 5 DESC;