Which two statements are true regarding the COUNT function? (Choose two.)
A. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
B. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.
C. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.
D. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.
E. It can only be used for NUMBER data types.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
BD
BD
D)All aggregate functions except COUNT(*), GROUPING, and GROUPING_ID ignore nulls.
E) It works on both numeric and non-numeric data types