Question

How can a SQL developer add a key on a table?

(a) While creating a table

(b) With Alter table command

(c) With SQL server Properties window

(d) All of the Mentioned

I have been asked this question by my college professor while I was bunking the class.

My question comes from Foreign, Candidate, Primary, Composite, Unique Keys in division Planning Oracle Applications of Oracle

Answer 1

Right answer is (d) All of the Mentioned

Easiest explanation: Adding key on a table can be done with all the above mentioned way.