试题详情
- 单项选择题Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）
A、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
B、ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
C、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
D、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E、ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
关注下方微信公众号，在线模考后查看
热门试题
- Examine the structu
- Which object privile
- ClicktheExhibitbutto
- You need to create a
- Evaluate this SQL s
- Which syntax turns a
- The CUSTOMERS table
- You need to change t
- Which SQL statement
- Examine the data fr
- The user Alice wants
- The STUDENT_GRADES
- In which scenario wo
- Which two are charac
- The DBA issues this
- Examine these state
- What does the TRUNCA
- Which four are valid
- The CUSTOMERS table
- Which statement adds