Can a table have two primary keys?
Answer Posted / subbarayulu
No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a pl/sql block?
What are three advantages to using sql?
Is record in oracle pl sql?
What is pl sql and why it is used for?
How to change the order of columns in Oracle SQL Plus ?
Can a key be both primary and foreign?
What is sql clause?
Explain dml and ddl?
What is a field in a database?
Explain the difference between rename and alias?
How can you view the errors encountered in a trigger?
How to rename a table?
what is the difference between sql and t-sql? : Transact sql
What is a subquery in sql?
What makes a good primary key?