View the exhibit and examine the ORDERStable.
ORDERS
Null? Type
Name
ORDER ID NOT NULL NUMBER(4)
ORDATE DATE DATE
CUSTOMER ID NUMBER(3)
ORDER TOTAL NUMBER(7,2)
The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

• A.ALTER TABLE orders
  ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• B.ALTER TABLE orders
  MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• C.ALTER TABLE orders
  MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
• D.ALTER TABLE orders
  ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CREATE SEQUENCEstatement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The sequence SEQ1has generated numbers up to the maximum limit of 200. You issue the following SQL statement:
SELECT seq1.nextval FROM dual;
What is displayed by the SELECTstatement?

• A.10
• B.100
• C.an error
• D.1

Comment: *

Name: *

Email: *

Verification: *

The sales table has columns prod_id and quantity_sold of data type number. Which two queries execute successfully?

• A.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
• B.SELECT prod Id FROH sales NHERE quantity sold > 55000 3RODI BY prod_id HAVING COUNT(*) > 10;
• C.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• D.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
• E.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
  COUNT(*) > 10 GROUP BY COUNT(*) > 10;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins?

• A.A full outer join must use Oracle syntax.
• B.Outer joins can be used when there are multiple join conditions on two tables.
• C.A full outer join returns matched and unmatched rows.
• D.A left or right outer join returns only unmatched rows.
• E.An inner join returns matched rows.
• F.Outer joins can only be used between two tables per query.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

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

• A.It shows COST_REMARK for all the promos in the promo category 'TV'.
• B.It produces an error because the subquery gives an error.
• C.It produces an error because subqueries cannot be used with the CASE expression.
• D.It shows COST_REMARK for all the promos in the table.

Comment: *

Name: *

Email: *

Verification: *