what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 8126 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
List the ways to get the count of records in a table?
Explain the uses of database trigger.
Can we call a function containing dml statements in a select query?
What are the different types of a subquery?
Mention what is the plv (pl/vision) package offers?
how many sql dml commands are supported by 'mysql'? : Sql dba
Are subqueries faster than joins?
How do you create a unique index?
What is sql key?
What is synchronized subquery?
What is transaction control language (tcl)?
What is string data type in sql?
How do I start pl sql?
What is pl sql code?
Is pl sql and postgresql same?
