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 do u mean by orphan users, how will u list them in the DB
Explain cdc and sql injection?
What are different types of collation sensitivity?
Which TCP/IP port does SQL Server run on?
Can you move the resources after pausing the node? : sql server database administration
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
4 Answers Credit Suisse, GCU, Symphony, TCS,
Explain the steps needed to create a scheduled job?
What are the different types of stored procedures?
How you can move data or databases between servers and databases in sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How many columns can exist together per table?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?