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
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)- A16% (5)
- B9% (3)
- C72% (23)
- D3% (1)
Community Discussion
No community discussion yet for this question.
