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 4800

The CUSTOMERS table has the following structure:
 
Exhibit:
 
You need to write a query that does the following task:
* Display the first name and tax amount of the customers. Tax is 5% of their credit limit * Only those customers whose income level has a value should be considered
* Customers whose tax amount is null should not be considered Which statement accomplishes all the required tasks?

Option A

A.    SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
WHERE cust_income_level <> NULL AND
tax_amount <> NULL
 

Option B

B.    SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
WHERE cust_income_level IS NOT NULL AND
tax_amount IS NOT NULL
 

Option C

C.    SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
WHERE (cust_income_level,tax_amount) IS NOT NULL
 

Option D

D.    SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
WHERE cust_income_level IS NOT NULL AND
credit limit IS NOT NULL
 

Correct Answer D
Explanation


Question ID 4801

You need to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand
Seven. Which SQL statement would give the required result?
 

Option A

A.    SELECT TO_CHAR(TO_DATE('11-oct-2007'),'fmDspth "of" Month, Year') FROM DUAL;
 

Option B

B.    SELECT TO _CHAR('11-oct-2007','fmDspth "of" Month, Year')
FROM DUAL;
 

Option C

C.    SELECT TO _CHAR(TO_DATE('11-oct-2007'),'fmDspth of Month, Year')
FROM DUAL;
 

Option D

D.    SELECT TO _DATE(TO_CHAR('11-oct-2007','fmDspth "of" Month, Year')) FROM DUAL;
 

Correct Answer A
Explanation

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