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
What is model database in sql server?
Explain primary key and foreign key constraints?
What are sql servers used for?
What is database isolation in sql server? : sql server database administration
What is simple indexing method?
what is a join and explain different types of joins? : Sql server database administration
How to write character string constants or literals in ms sql server?
What is mssql?
Write the syntax for stuff function in an sql server?
What are the acid properties?
Explain the ways to controlling cursor behavior?
What is intellisense?
What is the meaning of resultset type_scroll_insensitive?
How you can add messages to the nt event log from within a stored procedure?
List all the types of user-defined functions?