Oracle - FROM WHERE ORDER BY GROUP BY HAVING Clauses MCQ

Oracle – FROM WHERE ORDER BY GROUP BY HAVING Clauses

1 / 18

1. What is the primary purpose of the Oracle FROM clause?

Orders the result set

Specifies the tables to be queried

Groups rows by a column

Filters rows based on conditions

2 / 18

2. Which SQL clause is used to filter rows in Oracle SQL?

HAVING

WHERE

GROUP BY

FROM

3 / 18

3. In Oracle SQL, which clause is used to sort the result set in ascending or descending order?

GROUP BY

WHERE

FROM

ORDER BY

4 / 18

4. What does the Oracle GROUP BY clause do?

Groups rows by one or more columns

Calculates the average value

Filters rows based on conditions

Orders rows in ascending order

5 / 18

5. In Oracle SQL, what is the purpose of the HAVING clause?

Groups rows by a column

Filters grouped rows based on conditions

Filters individual rows based on conditions

Orders rows in descending order

6 / 18

6. Which SQL clause is used to filter grouped rows in Oracle SQL?

FROM

WHERE

HAVING

ORDER BY

7 / 18

7. What is the primary role of the Oracle ORDER BY clause?

Filters rows based on conditions

Groups rows by a column

Counts the number of rows

Sorts the result set

8 / 18

8. In Oracle SQL, what does the GROUP BY clause do when used in a query?

Filters rows based on conditions

Orders rows in ascending order

Groups rows by one or more columns

Calculates the sum of values

9 / 18

9. What is the primary purpose of the HAVING clause in Oracle SQL?

Groups rows by a column

Orders rows in descending order

Filters individual rows based on conditions

Filters grouped rows based on conditions

10 / 18

10. In Oracle SQL, what is the primary function of the ORDER BY clause in a query?

Groups rows by a column

Filters rows based on conditions

Counts the number of rows

Sorts the result set

11 / 18

11. What is the outcome of using the GROUP BY clause in Oracle SQL?

Rows are grouped based on one or more columns

Rows are filtered based on conditions

Rows are counted

Rows are ordered in ascending order

12 / 18

12. Which SQL clause is used to sort the result set in Oracle SQL?

WHERE

FROM

ORDER BY

GROUP BY

13 / 18

13. In Oracle SQL, what does the HAVING clause allow you to do?

Filter individual rows based on conditions

Group rows by a column

Sort rows in descending order

Filter grouped rows based on conditions

14 / 18

14. What is the primary role of the Oracle ORDER BY clause in a query?

Groups rows by a column

Filters rows based on conditions

Sorts the result set

Calculates the average value

15 / 18

15. In Oracle SQL, what is the primary function of the GROUP BY clause in a query?

Filters rows based on conditions

Calculates the sum of values

Groups rows by one or more columns

Orders rows in ascending order

16 / 18

16. What is the purpose of the HAVING clause in Oracle SQL?

To order rows in descending order

To filter grouped rows based on conditions

To filter individual rows based on conditions

To group rows by a column

17 / 18

17. What is the primary function of the Oracle ORDER BY clause in a query?

Sorts the result set

Groups rows by a column

Filters rows based on conditions

Counts the number of rows

18 / 18

18. In Oracle SQL, what is the primary outcome of using the GROUP BY clause in a query?

Rows are counted

Rows are grouped based on one or more columns

Rows are ordered in ascending order

Rows are filtered based on conditions

Your score is

Oracle – FROM WHERE ORDER BY GROUP BY HAVING Clauses MCQ