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)…

Question

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

• A
  2% (1)
• B
  84% (38)
• C
  4% (2)
• D
  9% (4)

No community discussion yet for this question.