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 4761

See the Exhibit and Examine the structure of the CUSTOMERS table:
Exhibit:
 
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

Option A

A.    SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers;
 

Option B

B.    SELECT NVL(cust_credit_limit*.15,'Not Available')"NEW CREDIT" FROM customers;
 

Option C

C.    SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT"
FROM customers;
 

Option D

D. SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT"
FROM customers;
 

Correct Answer C
Explanation


Question ID 4762

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 SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;
 

Option B

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

Option C

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

Option D

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

Option E

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

Correct Answer A,C
Explanation

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