AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-061





Question ID 2331

Which two statements are true regarding the count function?

Option A

A.    The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
 

Option B

B.    Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
 

Option C

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

Option D

D.    Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV AMT column.

 

Option E

E.    A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.

Correct Answer B,D
Explanation


Question ID 20997

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

Option A

It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Option B

It produces an error because positional notation cannot be used in the order by clause with set operators.

Option C

It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Option D

It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!