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 4872

Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)
 

Option A

A.    addition
 

Option B

B.    subtraction
 

Option C

C.    raising to a power
 

Option D

D.    finding the quotient
 

Option E

E.    finding the lowest value
 

Correct Answer A,C,E
Explanation


Question ID 4873

View the Exhibit and examine the structure of the PROMOTIONS table. You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:
 
1.    The promo name should not begin with 'T' or 'N'.
2.    The promo should cost more than $20000.
3.    The promo should have ended after 1st January 2001. Which WHERE clause would give the required result?
 

Option A

A.    WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'
 

Option B

B.    WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR promo_cost > 20000 OR promo_end_date > '1-JAN-01'
 

Option C

C.    WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'
 

Option D

D.    WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND(promo_cost > 20000 AND promo_end_date > '1-JAN-01')

Correct Answer C
Explanation

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