Oracle
1Z0-047 · Question #226
1Z0-047 Question #226: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #226. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table: ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id) USING INDEX emp_id_idx; Which statement is true regarding the effect of the command?
Options
- AThe PRIMARY KEY is created along with a new index.
- BThe PRIMARY KEY is created and it would use an existing unique index.
- CThe PRIMARY KEY would be created in a disabled state because it is using an existing index.
- DThe statement produces an error because the USING clause is permitted only in the CREATE TABLE
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.