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

My Personal Notes arrow_drop_up

Save