Which two statements are true regarding the COUNT function? (Choose two.)

Question

Options

• ACOUNT(*) returns the number of rows including duplicate rows and rows containing NULL value
• BCOUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and
• CCOUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates
• DA SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE
• EThe COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types

• A
  79% (23)
• B
  7% (2)
• D
  3% (1)
• E
  10% (3)

Explanation

Using the COUNT Function The COUNT function has three formats: COUNT(DISTINCT expr) COUNT() returns the number of rows in a table that satisfy the criteria of the SELECT statement, including duplicate rows and rows containing null values in any of the columns. If a WHERE clause is included in the SELECT statement, COUNT() returns the number of rows that satisfy the condition in the WHERE clause. COUNT(expr) returns the number of non-null values that are in the column identified by expr. COUNT(DISTINCT expr) returns the number of unique, non-null values that are in the column identified by expr.

No community discussion yet for this question.