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 4866

You need to display the date ll-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('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL:
 

Option B

B.    SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL;
 

Option C

C.    SELECT TO_CHAR(TO_DATE('ll-oct-2007'), 'miDdthsp "of* Month. Year') FROM DUAL;
 

Option D

D.    SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL:
 

Correct Answer C
Explanation


Question ID 4867

View the Exhibit and examine the structure of the PRODUCTS table. All products have a list price. You issue the following command to display the total price of each product after a discount of 25%
and a tax of 15% are applied on it. Freight charges of S100 have to be applied to all the products.
SQL>SELECT prod_name, prod_list_price - (prod_list_jmce*(25/100))
AS "TOTAL PRICE"
FROM products:
What would be the outcome if all the parentheses are removed from the above statement?
 

Option A

A.    It produces a syntax error.
 

Option B

B.    The result remains unchanged.
 

Option C

C.    The total price value would be lower than the correct value.
 

Option D

D.    The total price value would be higher than the correct value.
 

Correct Answer B
Explanation

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