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 4820

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

Option A

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

Option B

B.    SELECT promo_id, DECODE(promo_cost,10000, DECODE(promo_category,'G1',promo_cost*.25,NULL), NULL) "Catcost"
FROM promotions;
 

Option C

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

Option D

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

Correct Answer A,B
Explanation


Question ID 4821

Which statement is true regarding the COALESCE function?
 

Option A

A.    It requires that at least one of the expressions in the list must have a NOT NULL value
 

Option B

B.    It can have a maximum of five expressions in a list
 

Option C

C.    It requires that all expressions in the list must be of the same data type
 

Option D

D.    It returns the highest NOT NULL value in the list for all rows
 

Correct Answer C
Explanation

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