Q34. Which two statements are true regarding the COUNT function?
A. COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns.
B. COUNT (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
C. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
D. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
E. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.
Correct Answer: AC