Exam 1z0-071 Topic 15 Question 122 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 122
Topic #: 15

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

A. ALTER TABLE ordersMODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id); B. ALTER TABLE ordersADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id); C. ALTER TABLE ordersMODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id); D. ALTER TABLE ordersADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business