what is the different between unique+not null & primary key,
Answer Posted / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is clustered index sql?
What is trigger in pl sql?
Explain alias in sql?
Can dml statements be used in pl/sql?
What is the unique index?
What is dml with example?
What is sql query limit?
What is sql lookup?
Mention what is the use of function "module procedure" in pl/sql?
What is the difference between a database and a relational database?
What is the difference between left join and right join?
Explain raise_application_error.
What is flag in sql?
What is percent sign in sql?