Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the
CUSTOMERS table holds a value?

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the
CUSTOMERS table holds a value?

A.
ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS
NOT NULL;

B.
ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

C.
ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT
NULL;

D.
ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;

E.
ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name
IS NOT NULL;

F.
ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name
NOT NULL;

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

juli

juli

ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK (customer_name IS NOT NULL); –done
ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK (customer_name NOT NULL); –not done
ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK (customer_name) IS NOT NULL; –not done

Reply