Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 9454 Views
- PreVator, I also Faced
- E-Mail Answers
Answer Posted / nitin gupta
Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.
primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the set operators in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What information is needed to connect sql*plus an oracle server?
what is sql profiler? : Sql dba
What are the different dcl commands in sql?
What is sql partition function?
how to escape special characters in sql statements? : Sql dba
What is cursor and its types?
what are properties of a transaction? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
Is id a reserved word in sql?
What is a stored procedure in sql with example?
What are the basic techniques of indexing?
How would you convert date into julian date format?
Why are indexes and views important to an organization?
