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 4789

Which statement is true regarding the INTERSECT operator?
 

Option A

 
A.    The number of columns and data types must be identical for all SELECT statements in the query
 

Option B

B.    It ignores NULL values
 

Option C

C.    Reversing the order of the intersected tables the result
 

Option D

D.    The names of columns in all SELECT statements must be identical
 

Correct Answer A
Explanation


Question ID 4790

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
You need to display all promo categories that do not have 'discount' in their subcategory. Which two SQL statements give the required result? (Choose two.)

Option A

A.    SELECTpromo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount'
 

Option B

B.    SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount'
 

Option C

C.    SELECTpromo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount'
 

Option D

D.    SELECTpromo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount'
 

Correct Answer A,B
Explanation

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