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- 1z1-051





Question ID 4727

See the Exhibit and examine the structure and data in the INVOICE table: Exhibit:
 
Which two SQL statements would executes successfully? (Choose two.)

Option A

A.    SELECT MAX(inv_date),MIN(cust_id) FROM invoice;
 

Option B

B.    SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;
 

Option C

C.    SELECT (AVG(inv_date) FROM invoice;
 

Option D

D.    SELECT AVG(inv_date - SYSDATE),AVG(inv)amt) FROM invoice;
 

Correct Answer A,D
Explanation


Question ID 4728

Which three statements are true regarding sub queries? (Choose three.)
 

Option A

A.    Multiple columns or expressions can be compared between the main query and sub query
 

Option B

B.    Main query and sub query can get data from different tables
 

Option C

C.    Sub queries can contain GROUP BY and ORDER BY clauses
 

Option D

D.    Main query and sub query must get data from the same tables
 

Option E

E.    Sub queries can contain ORDER BY but not the GROUP BY clause
 

Option F

F.    Only one column or expression can be compared between the main query and subqeury
 

Correct Answer A,B,C
Explanation

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