Prev Question
Next Question

Which two statements are true regarding the COUNT function?

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 NULL
values in the INV_AMT column.

C.
COUNT (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value
in the CUST_ID column.

D.
COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of
the columns.

E.
The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *