Multiple choice technology databases

We can nest Group Functions

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle SQL, you cannot directly nest group functions like AVG(MAX(salary)) at the same level. Group functions return a single value per group, so nesting them directly doesn't make logical sense. However, you can use group functions in subqueries or the HAVING clause where they operate on different grouping levels. The claimed answer 'False' is correct.

Keep practicing — related questions