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…

Question

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.

• A
  7% (2)
• B
  79% (23)
• C
  3% (1)
• D
  10% (3)

No community discussion yet for this question.