The AVG function only includes non-NULL values in its calculations._________________________
Correct Answer:
Verified
Q32: The HAVING clause is used to restrict
Q33: When the SELECT statement includes both WHERE
Q34: The COUNT(*)function can be used to count
Q35: The TOTAL function is used to calculate
Q36: The optional DISTINCT keyword instructs Oracle12c to
Q38: The only group function that includes NULL
Q39: The COUNT function is used to total
Q40: Single-row functions return one result per group
Q41: Functions that return one result per group
Q42: The VAR function is used to determine
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents