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 is pl sql collection?
What is the difference between database trigger and stored procedure?
Difference between global and parameter variables?
How do you declare a constant?
What is clause?
how do you know if your mysql server is alive? : Sql dba
What is the difference between subquery and correlated query?
Can we join same table in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Explain how can you save or place your msg in a table?
what is the command line end user interface - mysql? : Sql dba
What does sql stand for?
What is clause in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
What are the two types of exceptions in pl/sql?