View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?
ALTER TABLE orders

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

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:

You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?

• A.SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN department_details d ON (c.department_id=d. department_id)
• B.SELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN course_details c USING (department_id)
• C.SELECT c.course_id, d.department_id FROM course_details c RIGHT OUTER JOIN .department_details d ON (c.depatrment_id=d.department_id)
• D.SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN department_details d ON (c.department_id<>d. department_id)

Comment: *

Name: *

Email: *

Verification: *

Examine the types and examples of relationship that follows: (Choose the best answer.)
1 One-to-one a) teacher to Student
2 One-to-many b) Employees to Manager
3 Many-to-one c) Person to SSN
4 Many-to-many d) Customers to Products
Which option indicates correctly matched relationships?

• A.1-a, 2-b, 3-c, and 4-d
• B.1-c, 2-d, 3-a, and 4-b
• C.1-c, 2-a, 3-b, and 4-d
• D.1-d, 2-b, 3-a, and 4-c

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.

You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:
SQL>SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?

• A.The statement would not execute because inline views and outer joins cannot be used together.
• B.The statement would execute successfully to produce the required output.
• C.The statement would not execute because the GROUP BY clause cannot be used in the inline.
• D.The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement
SQL>SELECT promo_id, prom _category FROM promotions
WHERE promo_category='Internet' ORDER BY promo_id
UNION
SELECT promo_id, promo_category FROM Pomotions
WHERE promo_category = 'TV'
UNION
SELECT promoid, promocategory FROM promotions WHERE promo category='Radio' Which statement is true regarding the outcome of the above query?

• A.It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.
• B.It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.
• C.It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.
• D.It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.

Comment: *

Name: *

Email: *

Verification: *