READ Free Dumps For Oracle- 1z1-051
Question ID 4800 | The CUSTOMERS table has the following structure: |
Option A | A. SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers |
Option B | B. SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers |
Option C | C. SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers |
Option D | D. SELECT cust_first_name,cust_credit_limit * .05 AS TAX_AMOUNT FROM customers |
Correct Answer | D |
Question ID 4801 | You need to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand |
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') |
Option C | C. SELECT TO _CHAR(TO_DATE('11-oct-2007'),'fmDspth of Month, Year') |
Option D | D. SELECT TO _DATE(TO_CHAR('11-oct-2007','fmDspth "of" Month, Year')) FROM DUAL; |
Correct Answer | A |