Question

63. In SQL,_____ functions are used to implement calculation based upon a particular column.
(A) Aggregate
(B) ORDER BY
(C) IN
(D) BETWEEN

Answer 1

Answer:

Option (A) Aggregate hoga

Answer 2

In SQL, aggregate functions used to implement calculation based upon a particular column.

Answer: Option A

Explanation:

In SQL, aggregate functions are utilised to perform all types of operations across the entire column, regardless of number of rows. The ‘aggregate functions’ are listed below.

• SUM is used for adding all values together in a provided column.

• COUNT refers to counting of rows (how many rows) in provided column.

• MAX and MIN functions will return the highest and lowest values of a specific column respectively.

• AVG refers to the average of selected values.