Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
A. Aggregate functions can be nested to any number of levels. -> Can be nested upto one level only.
B. The AVG function implicitly converts NULLS to zero. -> AVG function ignores NULLS.
C. The MAX and MIN functions can be used on columns with character data types. -> True
D. Aggregate functions can be used in any clause of a SELECT statement. -> It can't be used with where clause.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
archit4321
2 weeks, 5 days agokesammy9
1 year, 2 months ago