多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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;
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题