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

Authored by David Turner

Computers

12th Grade

Used 6+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

25 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

FROM

SELECT

WHERE

ORDER BY

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SELECT

FROM

WHERE

GROUP BY

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

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

ALL

COLUMNS

(Nothing)

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

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 Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

20 questions

UID uCertify Chapter 9 Test

Quiz

•

8th - 12th Grade

21 questions

real life application of robotics

Quiz

•

12th Grade

20 questions

Photoshop Dasar 1

Quiz

•

KG - Professional Dev...

21 questions

Computational Thinking

Quiz

•

5th - 12th Grade

20 questions

UNIT 4- ADMINISTRATION

Quiz

•

12th Grade

20 questions

Excel Vocabulary and Screen Parts

Quiz

•

8th - 12th Grade

20 questions

Design your website

Quiz

•

7th - 12th Grade

20 questions

The Internet (ISP)

Quiz

•

12th Grade - University

Popular Resources on Wayground

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

6 questions

Rule of Law

Quiz

•

6th - 12th Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

10 questions

Movie Trivia

Quiz

•

KG - 2nd Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Computers

16 questions

Module 1 Topic 2 Vocabulary Test

Quiz

•

9th - 12th Grade

18 questions

[AP CSP] Python Coding: Conditionals + List + Algo Dev

Quiz

•

9th - 12th Grade

20 questions

Early Computing

Quiz

•

7th - 12th Grade

CFT SQL Final Practice

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