CFT SQL Final Practice

Front

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

Back

SELECT

Front

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

Back

FROM

Front

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

Back

WHERE

Front

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

Back

ORDER BY

Front

To retrieve all columns from the employees table, what should you use after SELECT? Options: * , ALL , COLUMNS , (Nothing)

Back

*

Front

What SQL clause is used to limit the rows returned in the result set? Options: SELECT, LIMIT, WHERE, FROM

Back

WHERE

Front

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

Back

GROUP BY

Front

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

Back

SUM

Front

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

Back

WHERE

Front

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

Back

SELECT * FROM employees WHERE salary > 55000