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 4832

See the Exhibit and examine the structure of the PROMOTiONS table:
Exhibit:
 
Using the PROMITIONS table you need to find out the names and cost of all the promos done on TV 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 promo_name, promo_cost
 
FROM promotions
WHERE promo_category IN ('TV','internet') AND
promo_end_date BETWEEN '15-MAR-00' AND '15-OCT-00';
 

Option B

B.    SELECT promo_name, promo_cost
FROM promotions
WHERE promo_category = 'TV' OR promo_category ='internet'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_category = 'TV' OR promo_category ='internet') AND (promo_end_date >= '15-MAR-00' AND promo_end_date <='15-OCT-00');
 

Option D

D.    SELECT promo_name, promo_cost
FROM promotions WHERE (promo_category BETWEEN 'TV' AND'internet') AND (promo_end_date IN ('15-MAR-00' AND '15-OCT-00');
 

Correct Answer A,C
Explanation


Question ID 4833

View the Exhibit and examine the structure of the CUSTOMERS table. You have been asked to produce a report on the CUSTOMERS table showing the customers details sorted in descending order of the city and in the descending order of their income level in each city. Which query would accomplish this task?
 

Option A

A. SELECT cust_city, cust_income_level, cust_last_name
 
FROM customers
ORDER BY cust_city desc, cust_income_level DESC;
 

Option B

B.    SELECT cust_city, cust_income_level, cust_last_name FROM customers
ORDER BY cust_ income_level desc, cust_city DESC;
 

Option C

C.    SELECT cust_city, cust_income_level, cust_last_name FROM customers
ORDER BY (cust_city, cust_income_level) DESC;
 

Option D

D.    SELECT cust_city, cust_income_level, cust_last_name FROM customers
ORDER BY cust_city, cust_income_level DESC;
 

Correct Answer A
Explanation

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