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 4864

View the Exhibit and examine the structure of ORD and ORDJTEMS tables. The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in the ORDJTEMS table. Which two CREATE INDEX statements are valid? (Choose two.)
 
 

Option A

A.    CREATE INDEX ordjdxl ON ord(ord_no):
 

Option B

B.    CREATE INDEX ord_idx2 ON ord_irems(ord_no);
 

Option C

C.    CREATE INDEX ord_idx3 ON ord_items(item no);
 

Option D

D.    CREATE INDEX ord_idx4
ON ord.ord_itenis(ord_DD, ord_date.qry):
 

Correct Answer B,C
Explanation


Question ID 4865

View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV1 and 'internet' that ended in the time interval 15th March '00 to 15th October '00.Which two queries would give the required result? (Choose two.)
 
 

Option A

A.    SELECT promoname, promocosl
FROM promotions
WHERE promo_category IN ('TV7', 'internet') AND
promo_end_date BETWEEN '15-MAR-OO' AND '15-OCT-00':
 

Option B

B.    SELECT promo_name. promo_cost FROM promotions
WHERE promo_categoiy = TV OR promo_category ='inteniet' AND promo_end_date >='15-MAR-00' OR promo_end_date <='15-OCT-00':
 

Option C

C.    SELECT promo_name. promo_cost FROM promotions
WHERE (promo_categoiy BETWEEN TV AND 'internet') AND (promo_end_date IN ('15-MAR-O0'.'15-OCT-O0'));
 

Option D

D.    SELECT promo_name. promo_cost
FROM promotions WHERE (promo_category = TV OR promo_category ='inteniet') AND (promo_end_date >='l 5-MAR-00' AKD promo_end_date <='l 5-OCT-00'):
 

Correct Answer A,D
Explanation

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