Read online free dumps for Oracle- 1z1-051

Here you can read online questions and answers for Oracle Exam 1z1-051 (Oracle Database 11g SQL Fundamentals I Exam ) 100% free...

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