READ Free Dumps For Oracle- 1z1-051
Question ID 4755 | You work as a database administrator at ABC.com. You study the exhibit carefully. |
Option A | A. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions) AND |
Option B | B. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT promo_begin_date FROM promotions |
Option C | C. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ANY (SELECT promo_begin_date FROM promotions |
Option D | D. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date IN (SELECT promo_begin_date FROM promotions) |
Correct Answer | B |
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 |
Option B | B. SELECT cust_last_name,cust_credit_limit FROM customers |
Option C | C. SELECT cust_last_name,cust_credit_limit FROM customers |
Option D | D. SELECT cust_last_name,cust_credit_limit |
Correct Answer | B,C |