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 4860

You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Winch two queries would achieve the required result? (Choose two.)
 

Option A

A.    SELECT cust_ last_name. cust_credit_limit FROM customers ORDER BY cust_ credit_limit DESC:
 

Option B

B.    SELECT cust_ last_name. cust_credit_limit FROM customers ORDER BY cust_ credit_limit:
 

Option C

C.    SELECT cust_ last_name. cust_credit_limit FROM customers ORDER BY cust_ credit_limit NULLS LAST:
 

Correct Answer B,C
Explanation


Question ID 4861

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
PRODJD NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD ID PROD PRICE
100 $234.55
101 $6,509.75
102 $1,234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?
 

Option A

A.    SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:
 

Option B

B.    SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;
 

Option C

C.    SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:
 

Option D

D.    SELECT TO_NUMBER(TO_NUMBER(prod_price.,$99.999.99')* .25/$99.999.00') FROM PRICE_LIST:
 

Correct Answer C
Explanation

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