Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 23 of 50

Marks: +1, -0

View the exhibit and examine the ORDERS table.

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 ?

ALTER TABLE orders MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
ALTER TABLE orders ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
ALTER TABLE orders MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
ALTER TABLE orders ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

Validate

Go to Question:

Prev Question

Next Question