The optional keyword instructs Oracle11g to include only unique numeric values in the calculation. _________________________
Correct Answer:
Verified
Q23: The VARIANCE function is used to determine
Q25: Column aliases can be used in the
Q27: Group functions can only be nested to
Q29: Columns used to group data in the
Q30: SUM,AVG,and COUNT are all considered group functions._
Q31: The WHERE clause specifies which groups will
Q35: The TOTAL function is used to calculate
Q37: The AVG function only includes non-NULL values
Q38: The only group function that includes NULL
Q51: By default,the COUNT function uses the DISTINCT
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