Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 50 of 50

Marks: +1, -0

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

A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.
COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.
COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.
It can only be used for NUMBER data types.

Go to Question:

Prev Question