UGC-NET | UGC-NET CS 2017 Dec 2 | Question 17

In SQL, __________ is an Aggregate function.
(A) SELECT
(B) CREATE
(C) AVG
(D) MODIFY

Answer: (C)
Explanation: An aggregate function allows you to perform a calculation on a set of values to return a single scalar value. AVG, COUNT, MIN, MAX, SUM are aggregate functions.

In SQL SELECT is used to choose a column from a database table.
CREATE is used to create a DB table.
AVG is a aggregate function.
MODIFY is used to modify DB table content.

So,option (C) is correct.
Quiz of this Question