AMU 2026 — Computer PYQ

Q: How do I solve AMU 2026 Computer questions?

Practice AMU 2026 Computer previous year questions with step-by-step solutions on Mathem Solvex. Each question includes a detailed explanation and video solution to help you master the concept quickly.

Q: What is the difficulty level of AMU Computer questions?

AMU Computer questions range from moderate to advanced difficulty. Consistent practice with official previous year papers and topic-wise drills on Mathem Solvex is the most effective preparation strategy.

Q: Are AMU previous year papers available for free?

Yes. Mathem Solvex provides free access to AMU previous year question papers and topic-wise PDFs. You can download them or attempt them as timed live mock tests directly on the platform.

Question

AMU 2026 — Computer PYQ

AMU | Computer | 2026

Which of the following are valid aggregate functions in SQL?

I. AVG ( )

II. MAX ( )

III. ALL ( )

IV. COUNT ( )

Choose the correct answer:

Explanation

Aggregate functions in SQL perform a calculation on a set of values and return a single scalar value. Standard SQL supports five primary built-in aggregate functions:

AVG(): Calculates the arithmetic mean of a set of numeric values.
$AVG (X) = \frac{1}{n} i = 1 \sum n X_{i}$
MAX(): Identifies and returns the maximum value in a set.
MIN(): Identifies and returns the minimum value in a set.
SUM(): Computes the absolute mathematical sum of a numeric set.
COUNT(): Returns the total number of rows or non-null values matching the query criteria.

Why Statement III is Incorrect:

ALL is a logical operator/keyword used in SQL conditional clauses (typically inside a WHERE or HAVING clause paired with comparison operators like >, <, =) to compare a scalar value against every single value returned by a subquery. It is not an aggregate function and cannot be used to condense multiple rows into a single summary scalar output.

Therefore, statements I, II, and IV are valid aggregate functions, making option (c) the correct choice.