Oracle
1Z0-061 · Question #229
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?
The correct answer is C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL. See the full explanation below for the reasoning.
Question
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?
Options
- AALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT
- BALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS
- 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
How the community answered
(35 responses)- A3% (1)
- B11% (4)
- C74% (26)
- E9% (3)
- F3% (1)
Community Discussion
No community discussion yet for this question.