nerdexam
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)
  • A
    3% (1)
  • B
    11% (4)
  • C
    74% (26)
  • E
    9% (3)
  • F
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice