nerdexam
Oracle

1Z0-047 · Question #163

View the Exhibit and examine the description of the CUSTOMERS table. You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does…

The correct answer is C. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the description of the CUSTOMERS table. You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does not have numbers. Which SOL statement would you use to accomplish the task?

Exhibit

1Z0-047 question #163 exhibit

Options

  • AALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
  • BALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
  • CALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
  • DALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    9% (3)
  • C
    72% (23)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice