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 4755

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
 
You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

Option A

A.    SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions) AND
promo_category = 'INTERNET';

 

Option B

B.    SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT promo_begin_date FROM promotions
WHERE promo_category = 'INTERNET';
 

Option C

C.    SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ANY (SELECT promo_begin_date FROM promotions
WHERE promo_category = 'INTERNET';
 

Option D

D.    SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date IN (SELECT promo_begin_date FROM promotions)
WHERE promo_category = 'INTERNET';

Correct Answer B
Explanation


Question ID 4756

You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result? (Choose two.)
 
 

Option A

A.    SELECT cust_last_name,cust_credit_limit FROM customers
ORDER BY cust_credit_limit DESC;
 

Option B

B.    SELECT cust_last_name,cust_credit_limit FROM customers
ORDER BY cust_credit_limit NULLS LAST;
 

Option C

C.    SELECT cust_last_name,cust_credit_limit FROM customers
ORDER BY cust_credit_limit;
 

Option D

D.    SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_ last_name,cust_credit_limit NULLS LAST;
 

Correct Answer B,C
Explanation

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