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

Question

Options

• AALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
• BALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
• CALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
• DALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
• EALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
• FALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

• B
  14% (6)
• C
  77% (33)
• D
  5% (2)
• E
  2% (1)
• F
  2% (1)

No community discussion yet for this question.