Which is not a group function?
Count
Avg
Total
Max
You can use Avg or Sum group functions for any numeric data
True
False
COUNT(DISTINCT expr) returns
No. of rows in a table
No. of rows with non-null values of the expr
No. of distinct non-null values of the expr
None of the above
Which function forces group functions to include null values?
Group By
NVL
Order By
Having
All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause
Which is the clause used to restrict groups?
HAVING
WHERE
Group by
We can use Group functions in the WHERE clause
We can use MIN and MAX for any
Numeric data
Data type
Char data
None of the Above
We can nest Group Functions
Delete from Employee where grade = ‘Y’” deletes
All rows of the Employee table
Rows of the Employee table where the set grade is ‘Y’
Delete 1 row
Nothing will be deleted