To retrieve employees with a salary greater than $55,000, you can use:

SELECT * FROM employees WHERE salary > 55000

SELECT * FROM employees WHERE salary >= 55000

SELECT * FROM employees WHERE salary

To select the highest salary from the employees table, you can use:

SELECT MAX(salary) FROM employees

SELECT MIN(salary) FROM employees

SELECT AVG(salary) FROM employees

SELECT SUM(salary) FROM employees

What SQL command is used to find the average salary of employees?

SELECT AVERAGE(salary) FROM employees

To retrieve employees' names and their salaries in descending order of salary, you should use:

SELECT first_name, last_name FROM employees ORDER BY salary DESC

SELECT first_name, last_name FROM employees ORDER BY salary ASC

SELECT first_name, last_name FROM employees SORT BY salary DESC

SELECT first_name, last_name FROM employees SORT BY salary ASC

To retrieve employees in the IT department with a salary greater than $60,000, you can use:

SELECT * FROM employees WHERE department = 'IT' AND salary > 60000

SELECT * FROM employees WHERE department = 'IT' OR salary > 60000

SELECT * FROM employees WHERE department = 'IT' AND salary

SELECT * FROM employees WHERE department = 'IT' OR salary

To count the number of orders placed by each customer, you can use:

SELECT COUNT(order_id) FROM orders GROUP BY customer_id

SELECT COUNT(*) FROM orders GROUP BY customer_id

SELECT SUM(order_id) FROM orders GROUP BY customer_id

SELECT AVG(order_id) FROM orders GROUP BY customer_id

To retrieve the first 3 rows from a table called products, which SQL statement should you use?

SELECT * FROM products WHERE rownum

SELECT * FROM products FETCH FIRST 3 ROWS ONLY

What is the purpose of the SQL LIMIT function?

To limit the number of rows returned in the result set

To filter rows based on a condition

To group rows by a specific column

To sort rows in ascending order

To retrieve the last 5 orders from the orders table in descending order by order_date, which SQL statement should you use?

SELECT * FROM orders ORDER BY order_date DESC LIMIT 5

SELECT * FROM orders LIMIT 5 ORDER BY order_date DESC

SELECT * FROM orders ORDER BY order_date DESC FETCH LAST 5 ROWS ONLY

SELECT * FROM orders ORDER BY order_date DESC LIMIT 5 OFFSET 0

In SQL, the OFFSET keyword is used in conjunction with the LIMIT keyword to:

Skip a certain number of rows before retrieving the remaining rows

Specify the maximum number of rows to retrieve

Group rows based on a specific column

CFT SQL Final Practice

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Medium

David Turner

Used 4+ times

FREE Resource

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL command is used to select data from a table?

FROM

SELECT

WHERE

ORDER BY

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL clause specifies the table(s) from which to retrieve data?

SELECT

FROM

WHERE

GROUP BY

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL clause is used to filter data based on a specific condition?

FROM

SELECT

WHERE

GROUP BY

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL clause is used to sort the result set in ascending or descending order?

ORDER BY

GROUP BY

COUNT

SUM

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To retrieve all columns from the employees table, what should you use after SELECT?

*

ALL

COLUMNS

(Nothing)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL clause is used to limit the rows returned in the result set?

SELECT

LIMIT

WHERE

FROM

7.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

To select only the first_name and last_name columns from the employees table, what should you specify after SELECT?

first_name, last_name

(first_name, last_name)

"first_name", "last_name"

first_name and last_name

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

SIMULASI DIGITAL X

Quiz

•

1st Grade - University

20 questions

CPA JYSS 2018 Prelims Paper 1

Quiz

•

7th Grade - Professio...

20 questions

Pengenalan Robotika, Sensor dan Aktuator

Quiz

•

10th Grade - University

20 questions

Marketing Review

Quiz

•

9th - 12th Grade

20 questions

Key Applications 2

Quiz

•

9th - 12th Grade

22 questions

Programming Review

Quiz

•

9th - 12th Grade

20 questions

Web development

Quiz

•

9th - 12th Grade

20 questions

Excel Unit Review - Office 2016

Quiz

•

11th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

CFT SQL Final Practice

25 questions

What SQL command is used to select data from a table?

Which SQL clause specifies the table(s) from which to retrieve data?

What SQL clause is used to filter data based on a specific condition?

What SQL clause is used to sort the result set in ascending or descending order?

To retrieve all columns from the employees table, what should you use after SELECT?

What SQL clause is used to limit the rows returned in the result set?

To select only the first_name and last_name columns from the employees table, what should you specify after SELECT?

What SQL clause is used to group rows based on a specific column's values?

To count the number of employees in each department, you can use:

Which SQL function is used to calculate the sum of values in a numeric column?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers