If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
- 3 Answers
- 6523 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha sinha
1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the plv (pl/vision) package offers?
What is rownum and rowid?
Can we alter stored procedure?
What is dml and ddl?
what is bcp? When is it used?
Write a sql query to convert all character to uppercase after hypen.
What is sql in java?
How can you know that statistics should be updated?
What can you do with pl sql?
How does postgresql compare to "nosql"?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What are the set operators in sql?
How many rows can sqlite handle?
What is procedure and function?
How does stored procedure reduce network traffic?
