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 4796

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
Which statement would display the highest credit limit available in each income level in each city in the Customers table?

Option A

A.    SELECT cust_city, cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city, cust_income_level,cust_credit_limit;
 

Option B

B.    SELECT cust_city, cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_credit_limit , cust_income_level, cust_city

 

Option C

C.    SELECT cust_city, cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city, cust_income_level;
 

Option D

D.    SELECT cust_city, cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city , , cust_income_level ,MAX(cust_credit_limit);

Correct Answer C
Explanation


Question ID 4797

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit
 
Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001 starting with the latest promo.
Which query would give the required result? (Choose all that apply.)

Option A

A.    SELECT promo_name,promo_begin_date FROM promotions
WHERE promo_begin_date > '01-JAN-01' ORDER BY 1 DESC;
 

Option B

B.    SELECT promo_name,promo_begin_date "START DATE" FROM promotions
WHERE promo_begin_date > '01-JAN-01'
ORDER BY "START DATE" DESC;
 

Option C

C.    SELECT promo_name,promo_begin_date FROM promotions
WHERE promo_begin_date > '01-JAN-01' ORDER BY 2 DESC;
 

Option D

D.    SELECT promo_name,promo_begin_date FROM promotions
WHERE promo_begin_date > '01-JAN-01' ORDER BY promo_name DESC;
 
 

Correct Answer B,C
Explanation

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