Define candidate key, alternate key, composite key.
Answer Posted / amar
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 ? | 42 Yes | 14 No |
Post New Answer View All Answers
What is an indexing technique?
what do you understand by change data capture?
what stored procedure can you use to display the current processes? : Sql server administration
What is oltp (online transaction processing)?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What are different types of database indexes?
Is it safe to delete log files?
Please explain go command in sql server?
What is #table in sql server?
What is the difference between a fill factor of 100 and 0?
Write a SQL queries on Self Join and Inner Join.
Can sql server be linked with other servers like oracle?
How to provide column names in insert statements in ms sql server?
Difference between Sql server reporting services and Crystal reports?
Describe in brief system database.