Oracle
1Z0-047 · Question #131
1Z0-047 Question #131: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #131. The question stem and answer options stay visible for context.
Question
Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15)); Which statement is true regarding the PROD_ID_PK constraint?
Options
- AIt would be created only if a unique index is manually created first.
- BIt would be created and would use an automatically created unique index.
- CIt would be created and would use an automatically created no unique index.
- DIt would be created and remains in a disabled state because no index is specified in the command.
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.