Online Access Free 1Z0-051 Practice Test

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. Winch two queries would achieve the required result? (Choose two.)

• A.SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit:
• B.SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST:
• C.SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC:
• D.SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_last_name. cust_credit_limit NULLS LAST:

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 '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.)

• A.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');
• B.SELECT promo_name, promo_cost FROM promotions WHERE (promo_category BETWEEN 'TV' AND 'internet') AND (promo_end_date IN ('15-MAR-00','15-OCT-00'));
• C.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';
• D.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';

Which object privileges can be granted on a view?

• A.DELETE, INSERT, SELECT, UPDATE
• B.ALTER, DELETE, INSERT, SELECT
• C.DELETE, INSERT,SELECT
• D.none

View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.

Evaluate the following SQL statements:

Which statement is true regarding the output of the above query?

• A.It gives details of all promos irrespective of whether they have resulted in a sale or not
• B.It gives the details of promos for which there have been no sales
• C.It gives the details of promos for which there have been sales
• D.It gives details of product IDs that have been sold irrespective of whether they had a promo or not

View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.

Evaluate the following SQL statements:

Which statement is true regarding the above compound query?

• A.It shows products that have a cost recorded irrespective of sales
• B.It shows products that were sold and have a cost recorded
• C.It shows products that were sold but have no cost recorded
• D.It reduces an error