Answer Posted / shashi kishor prasad
In a Table there can have as many as 1024 colums but not
more than that is allowed. There can be only 1 primary key
in a table However you can combine multiple keys together to
act like a primary key that is called composite key.
Composite key is also a primary key, difference is that it
is a combination of no of colums that act as candidate key.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to recover from sql injection? : sql server security
Explain the concepts and capabilities of sql server?
What is cte (common table expression)?
How to set database to be single_user in ms sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are the tool windows in sql server management studio? : sql server management studio
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Differentiate between a local and a global temporary table?
How to use old values to define new values in update statements in ms sql server?
Explain system rowset functions?
How do you drop an index?
How to check if stored procedure is running in sql server?
What is difference between standardization and normalization?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Name and describe few console utilities for ssrs?