CFT SQL Final Practice

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

• FROM

• SELECT

• WHERE

• ORDER BY

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

• SELECT

• FROM

• WHERE

• GROUP BY

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

• FROM

• SELECT

• WHERE

• GROUP BY

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

• ORDER BY

• GROUP BY

• COUNT

• SUM

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

• *

• ALL

• COLUMNS

• (Nothing)

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

• SELECT

• LIMIT

• WHERE

• FROM

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

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

• WHERE

• ORDER BY

• GROUP BY

• SELECT

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

• COUNT(department)

• SUM(department)

• GROUP BY department

• ORDER BY department

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

• TOTAL

• COUNT

• SUM

• AVERAGE