Discussion
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Answer: B
Correct answer: False
A scalar aggregate is a single value, produced when an aggregate function is applied to a whole table with no GROUP BY - SELECT COUNT(*) FROM orders returns one row of one column.
The multiple-value case is the vector aggregate, produced when GROUP BY divides the rows into groups and the function is computed once per group. The statement swaps the two definitions, which is what makes it false; "scalar" means single-valued in this context as it does elsewhere.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development