Which of the following is the valid syntax for adding a PRIMARY KEY constraint to an existing

Question:

Which of the following is the valid syntax for adding a PRIMARY KEY constraint to an existing table?
a. ALTER TABLE tablename ADD CONSTRAINT PRIMARY KEY (columnname);
b. ALTER TABLE tablename ADD CONSTRAINT (columnname) PRIMARY KEY constraintname;
c. ALTER TABLE tablename ADD [CONSTRAINT constraintname] PRIMARY KEY;
d. None of the above is valid syntax.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: