Home » MCQs » Oracle MCQs » Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs

What is/are the clause(s) in the syntax of using primary key in ALTER TABLE statement?

12. What is/are the clause(s) in the syntax of using primary key in ALTER TABLE statement?

1. ALTER TABLE
2. ADD CONSTRAINT
3. PRIMARY KEY
4. All of the above

Answer: D) All of the above

Explanation:

The clauses in the syntax of using primary key in ALTER TABLE statement are -

1. ALTER TABLE
2. ADD CONSTRAINT
3. PRIMARY KEY