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 4838

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required result?
 

Option A

A.    SELECT cust_income_level. DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;
 

Option B

B.    SELECT DISTINCT cust_income_level. DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit"
FROM customers:
 

Option C

C.    SELECT DISTINCT cust_ income_ level || " || cust_ credit_limit * 0.50 AS "50% Credit Limit" FROM customers:
 

Option D

D.    SELECT cust_income_ level ||' '|| cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers:
 

Correct Answer C
Explanation


Question ID 4839

View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.)
 

Option A

A.    SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" FROM promotions;
 

Option B

B.    SELECT promo id. DECODE(promo_cost. 10000.
DECODE(promo_category. 'Gl\ promo_cost * 25. NULL). NULL) "Catcost" FROM promotions;
 

Option C

C.    SELECT promo_id. DECODE(NULLIF(promo_cost. 10000). NULL. promo_cost*.25, *N/A') "Catcost"
FROM promotions;
 

Option D

D.    SELECT promo_id. DECODE(promo_cost. >10000. 'High'. <10000. 'Low') "Range"FROM promotions;
 

Correct Answer A,B
Explanation

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