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

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

SELECT * FROM employees WHERE salary DESC LIMIT 5;

SELECT TOP 5 * FROM employees ORDER BY salary DESC;

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

SELECT * FROM employees SORT BY salary LIMIT 5 DESC;

Correct! Wrong!

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

SELECT

FROM

WHERE

ORDER BY

Correct! Wrong!

The WHERE clause is used to filter rows in a SQL query based on specific conditions. It restricts the data that is retrieved from the database.

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

SELECT * FROM employees SORT BY last_name;

SELECT * FROM employees WHERE last_name ORDER BY ASC;

SELECT * FROM employees ORDER BY last_name ASC;

SELECT * FROM employees WHERE ORDER BY last_name;

Correct! Wrong!

The correct SQL query to sort employees by their last_name in ascending order is SELECT * FROM employees ORDER BY last_name ASC;. The ASC keyword specifies ascending order, which is also the default if not explicitly stated.

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

SELECT * FROM employees WHERE salary > 50000;

SELECT * FROM employees ORDER BY salary > 50000;

SELECT * WHERE salary > 50000 FROM employees;

SELECT * ORDER BY salary > 50000 FROM employees;

Correct! Wrong!

The correct SQL query to retrieve rows where the salary is greater than 50000 is SELECT * FROM employees WHERE salary > 50000;

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

Filters rows based on a condition.

Sorts the result set based on one or more columns.

Combines rows from multiple tables.

Limits the number of rows returned by the query.

Correct! Wrong!

The ORDER BY clause is used to sort the result set of a query based on one or more columns in ascending or descending order.

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

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

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

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

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

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

Related Post