AGGREGATE FUNCTION IN SQL

a) Group data by column values

b) Group data by row values

c) Group data by column and row values

d) None of the mentioned

a) SELECT

b) WHERE

c) FROM

d) None of the mentioned

a) To filter out the row values

b) To filter out the column values

c) To filter out the row and column values

d) None of the mentioned

a) Aggregate functions

b) Operators

c) Clauses

d) All of the mentioned

a) COUNT

b) UPPER

c) LOWER

d) All of the mentioned

a) COUNT

b) b) SUM/AVG

c) MIN/MAX

d) All of the mentioned

a) GROUP BY

b) SELECT

c) WHERE

d) Both GROUP BY and WHERE

a) Aggregation of the field “name” of both table

b) Aggregation of the field “name” of table “department”

c) Sorting of the field “name”

d) None of the mentioned

a) Filter out all rows whose total emp_id below 2

b) Selecting those rows whose total emp_id>2

c) Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id>2

d) None of the mentioned