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,


DOWNLOAD & READ Free Dumps For Oracle- 1z1-051



You are reading online questions and answers for Oracle Exam 1z1-051 (Oracle Database 11g SQL Fundamentals I Exam ) 100% free... Please share this site which will help this community to grow...

Question ID 4725

Which statement is true regarding the UNION operator? Select all that apply.
 

Option A

A.    NULL values are not ignored during duplicate checking
 

Option B

B.    Names of all columns must be identical across all SELECT statements
 

Option C

C.    By default, the output is not sorted
 

Option D

D.    The number of columns selected in all SELECT statements need to be the same
 

Correct Answer A,D
Description Update Date and Time 2016-03-10 12:37:37

============================================================================

Question ID 4726

Evaluate the following SQL statements:
Exhibit:
 
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)

Option A

A.    ORDER BY "CUST_NO"
 

Option B

B.    ORDER BY "Last Name"
 

Option C

C.    ORDER BY CUST_NO
 

Option D

D.    ORDER BY 2,cust_id
 

Option E

E.    ORDER BY 2,1
 

Correct Answer B,D,E
Description Update Date and Time 2016-03-10 12:38:32

============================================================================