Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115548 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / swapna
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more columns is
called composite key.
| Is This Answer Correct ? | 348 Yes | 54 No |
Post New Answer View All Answers
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How can we get count of the number of records in a table?
What is normalization of database?
What are the different authentication modes in sql server? How can it be changed?
When columns are added to existing tables, what do they initially contain?
How to connect Azure federated root database and apply federation in entity framework?
What happens if null values are involved in arithmetic operations?
How to select some specific rows from a table in ms sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is transact-sql language?
What is the difference between a unique key and primary key?
Explain error and transaction handling in sql server?
What is Lock table in SQL?
What is Sqlpaging in SqlServer 2005 ?
How to create user messages with print statements in ms sql server?
