nerdexam
Oracle

1Z0-047 · Question #40

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. 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 #40 exhibit

Options

  • AALTER TABLE CUSTOMERS
  • BALTER TABLE CUSTOMERS
  • CALTER TABLE CUSTOMERS
  • DALTER TABLE CUSTOMERS

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    77% (20)
  • D
    12% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice