Oracle SQL Filtering and Sorting Quiz

Submit

3. Which clause should be used to filter aggregated data in Oracle SQL?

WHERE

HAVING

ORDER BY

GROUP BY

4. True or False: The % wildcard in LIKE represents zero or more characters.

True

False

Submit

6. What is the correct syntax for sorting with NULL values first in Oracle SQL?

ORDER BY col NULLS FIRST

ORDER BY col NULL FIRST

ORDER BY NULLS FIRST col

ORDER BY col FIRST NULLS

7. True or False: ORDER BY can reference columns not included in the SELECT list.

True

False

Submit

9. Which comparison operator is used to find values not equal to a specified value?

!=

Both A and B are correct

Neither A nor B is correct

10. True or False: The HAVING clause filters rows before grouping in Oracle SQL.

True

False

11. Which clause is used to filter rows based on specified conditions in Oracle SQL?

WHERE

FILTER

HAVING

SELECT

12. Which wildcard character represents any single character in a LIKE pattern?

%

_

*

?

13. What does the WHERE clause evaluate first in query execution?

Joins between tables

Individual row conditions

Aggregate functions

ORDER BY expressions

Submit

15. Which logical operator is used to combine multiple conditions where all must be true?

OR

AND

NOT

XOR

Submit

17. What is the correct syntax to sort by multiple columns in descending order?

ORDER BY col1 DESC, col2 DESC

ORDER BY DESC col1, col2

SORT BY col1 DESC, col2 DESC

ORDER col1, col2 DESCENDING

18. Which operator is used to check if a value falls within a range in Oracle SQL?

IN

BETWEEN

LIKE

EXISTS

Submit

20. What does the ORDER BY clause do in an SQL query?

Filters rows before display

Sorts result rows in ascending or descending order

Groups rows by column values

Joins multiple tables together

Oracle SQL Associate Data Filtering and Sorting Quiz

1. The IN operator allows you to specify ____ values to match in a WHERE clause.

2.

What first name or nickname would you like us to use?

2. In Oracle SQL, case sensitivity in string comparisons with WHERE is ____.

3. Which clause should be used to filter aggregated data in Oracle SQL?

4. True or False: The % wildcard in LIKE represents zero or more characters.

5. The NOT operator in a WHERE clause is used to ____ a condition.

6. What is the correct syntax for sorting with NULL values first in Oracle SQL?

7. True or False: ORDER BY can reference columns not included in the SELECT list.

8. In Oracle SQL, BETWEEN is inclusive of both the lower and upper ____ values.

9. Which comparison operator is used to find values not equal to a specified value?

10. True or False: The HAVING clause filters rows before grouping in Oracle SQL.

11. Which clause is used to filter rows based on specified conditions in Oracle SQL?

12. Which wildcard character represents any single character in a LIKE pattern?

13. What does the WHERE clause evaluate first in query execution?

14. In Oracle SQL, the IS NULL condition checks if a column contains a ____.

15. Which logical operator is used to combine multiple conditions where all must be true?

16. The LIKE operator in Oracle SQL is used to match ____.

17. What is the correct syntax to sort by multiple columns in descending order?

18. Which operator is used to check if a value falls within a range in Oracle SQL?

19. In Oracle SQL, the default sort order for ORDER BY is ____.

20. What does the ORDER BY clause do in an SQL query?