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

• A. SELECT promo_name,promo_begin_date
  FROM promotions
  WHERE promo_begin_date > '01-JAN-01'
  ORDER BY 1 DESC;
• B. SELECT promo_name,promo_begin_date "START DATE"
  FROM promotions
  WHERE promo_begin_date > '01-JAN-01'
  ORDER BY "START DATE" DESC;
• C. SELECT promo_name,promo_begin_date
  FROM promotions
  WHERE promo_begin_date > '01-JAN-01'
  ORDER BY 2 DESC;
• D. SELECT promo_name,promo_begin_date
  FROM promotions
  WHERE promo_begin_date > '01-JAN-01'
  ORDER BY promo_name DESC;

The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
CUSTOMER_ADDRESS VARCHAR2(150)
CUSTOMER_PHONE VARCHAR2(20)
You need to produce output that states "Dear Customer customer_name, ".
The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.
Which statement produces this output?

• A. SELECT 'Dear Customer ' || customer_name ',' FROM customers;
• B. SELECT "Dear Customer", customer_name || ',' FROM customers;
• C. SELECT 'Dear Customer ' || customer_name || ',' || FROM customers;
• D. SELECT "Dear Customer " || customer_name || "," FROM customers;
• E. SELECT 'Dear Customer ' || customer_name || ',' FROM customers;
• F. SELECT dear customer, customer_name, FROM customers;

View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for all customers in Tokyo'. Which two queries give the required result? (Choose two.)

• A. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
  FROM products p JOIN sales s JOIN customers c
  ON(p.prod_id=s.prod_id)
  ON(s.cust_id=c.cust_id)
  WHERE c.cust_city='Tokyo';
• B. SELECT c.cust_last_name,p.prod_name, s.quantity_sold FROM sales s JOIN products p USING(prod_id)
  JOIN customers c
  USING(cust_id)
  WHERE c.cust_city='Tokyo';
• C. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold FROM products p
  JOIN saless
  USING(prod_id)
  JOIN customers c
  USING(cust_id)
  WHERE c.cust_city='Tokyo';
• D. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
  FROM products p JOIN sales s
  ON(p.prod_id=s.prod_id)
  JOIN customers c
  ON(s.cust_id=c.cust_id)
  AND c.cust_city='Tokyo';

You need to perform these tasks:
-Create and assign a MANAGER role to Blake and Clark -Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results?

• A. CREATE ROLE manager;
  GRANT create table, create voew
  TO manager;
  GRANT manager ROLE TO BLAKE,CLARK;
• B. CREATE ROLE manager;
  GRANT create table, create view
  TO manager;
  GRANT manager TO BLAKE,CLARK;
• C. GRANT manager ROLE TO BLAKE,CLARK;
  GRANT create table, create voew
  TO BLAKE CLARK;
  ***MISSING***