If any possiable to use 2 primary key in single table?
How many primary key & foreign key used in each table(min &
max)?
Answers were Sorted based on User's Feedback
Answer / manikanta.srinu
Table can have only one primary key.243 foreign key can
poosiable for a table
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajkumar
A table can have only one foreign key and 253 foreign keys can have in a single table.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is referential integrity? What are the advantages of it?
4 Answers Descon, Digital Domain,
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Can you pass expressions to stored procedure parameters?
Difference between uniqe index and uniqe constraint?
What is the difference between index seek vs. Index scan?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the most common type of join?
how can you check the level of fragmentation on a table? : Sql server administration
What is a trace frag?
what is sql injection?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
How can I tell if sql server is 32 or 64 bit?