Oracle
1Z0-160 · Question #32
Which two statements are true regarding the count function?
The correct answer is B. Count (*) returns the number of rows including duplicate rows and rows containing null value in D. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the count function?
Options
- AThe count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
- BCount (*) returns the number of rows including duplicate rows and rows containing null value in
- CCount (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL
- DCount (distinct inv_amt) returns the number of rows excluding rows containing duplicates and
- EA select statement using the COUNT function with a DISTINCT keyword cannot have a where
How the community answered
(58 responses)- A12% (7)
- B81% (47)
- C5% (3)
- E2% (1)
Community Discussion
No community discussion yet for this question.