Interested to Buy Any Domain ? << Click Here >> for more details...
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 are logical/boolean operations in ms sql server?
What is the difference between row_number and dense_rank?
What is difference between after and before?
What are cursors and when they are useful?
What are cascading parameters in ssrs reports?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is the difference between osql and query analyzer?
What is extent? Types of extents?
Tell me what is use of except clause? How it differs from not in clause?
What is difference between createstatement and preparedstatement?
What is a join in sql? What are the types of joins?
Do you know what is difference between stored procedure and user defined function?
What is the difference between ‘having’ clause and a ‘where’ clause?
