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

Exhibit

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
  5% (2)
• B
  84% (31)
• C
  8% (3)
• D
  3% (1)

No community discussion yet for this question.