Oracle
1Z0-007 · Question #68
1Z0-007 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
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 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;
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.