nerdexam
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)
  • A
    12% (7)
  • B
    81% (47)
  • C
    5% (3)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-160 Practice