Interested to Buy Any Domain ? << Click Here >> for more details...
If any possiable to use 2 primary key in single table?
How many primary key & foreign key used in each table(min &
max)?
- 3 Answers
- 5020 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit kumar sharma
A table can have only one cluster index i.e. Primary key
and 249 non-cluster index i.e. foreign key.
Cluster Index have 3 leaf in b-tree and the last node
itself containing data.
While Non-cluster index have 4 leaf in b-tree and the 3rd
node containing the ref of data (4th node).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is partitioned view?
What are the features of Embedded SQL
Can we delete data from a view?
How global temporary tables are represented and its scope?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are the dis_advantages of stored procedures, triggers, indexes?
What are the components of sql server service broker?
Is sql different from sql server?
What is nolock?
What does ss stand for sexually?
Explain indexed views and partitioned view with their syntax.
Is it possible to update the views? If yes, how, if not, why?
What are the common performance issues in sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain transaction server auto commit?
