Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique
key?
- 4 Answers
- 8368 Views
- I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnana
1)primary key uses clustered index
unique key uses non-clustered index
2)primary key doesn't allow null values
but unique allows one null value
3)there is only one primary key but more than one unique
keys
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what is database replicaion? : Sql server database administration
Do you know what is lock escalation?
How to how to convert numeric expression data types using the convert() function??
mention different types of relationships in the dbms?
Write a query to find 5th highest amount paid from the customer table.
What is delete query?
What is database black box testing?
If the job running very slow what is the action you do
Should you normalize audio?
Do you think BCNF is better than 2NF & 3NF? Why?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are the advantages of using stored procedures in sql server?
What part does database design plays a role in performance of an sql server-based application?
How many servers can we create in a single subscription?
How do I find the sql server database version?
