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 4733

Evaluate the following SQL statement:
Exhibit:
 
Which statement is true regarding the outcome of the above query?

Option A

A.    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
 

Option B

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

Option C

C.    It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement
 

Option D

D.    It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators
 

Correct Answer A
Explanation


Question ID 4734

You need to calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr.
Which two SQL statements would give the required output? (Choose two.)
 

Option A

A.    SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL;
 

Option B

B.    SELECT SYSDATE - TO_DATE('01-JANUARY-2007) FROM DUAL;
 
 

Option C

C.    SELECT SYSDATE - '01-JAN-2007' FROM DUAL
 

Option D

D.    SELECT TO_DATE(SYSDATE,'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM DUAL;
 

Option E

E.    SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;
 

Correct Answer B,E
Explanation

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