3,694 views

3 Answers

Best answer
6 votes
6 votes

Answer A)

Avg is an aggregate function in SQL as it takes the average of a group of elements.

selected by
0 votes
0 votes

In SQL, an aggregate function is a function where the operation is performed on a groups of values to get the end result.

The aggregate functions in SQL are: max, min, count, avg, sum.

Group by is not an aggregate function even though it works on a group, because it doesn't generate one single value as the end result.

 

Option A

Answer:

Related questions

6 votes
6 votes
2 answers
1
go_editor asked Jun 10, 2016
3,877 views
Which commands are used to control access over objects in relational database?CASCADE & MVDGRANT & REVOKEQUE & QUISTNone of these
5 votes
5 votes
3 answers
2
go_editor asked Jun 10, 2016
7,439 views
Which of the following is correct with respect to Two phase commit protocol?Ensures serializabilityPrevents DeadlockDetects DeadlockRecover from Deadlock
4 votes
4 votes
2 answers
3
go_editor asked Jun 10, 2016
7,816 views
BCNF is not used for cases where a relation hasTwo (or more) candidate keysTwo candidate keys and compositeThe candidate key overlapTwo mutually exclusive foreign keys
8 votes
8 votes
5 answers
4
go_editor asked Jun 10, 2016
4,390 views
Which operation is used to extract specified columns from a table?ProjectJoinExtractSubstitute