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

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.

Step by Step Solution

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d None ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12122bb3_716096.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12122bb3_716096.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!