Sunday, July 4, 2010

3) SQL-Keys Defination

1) What is Primary Key?
Ans: - The column or attribute that is uniquely identifying the row of the table is called as Primary Key.

2) What is Foreign Key?
Ans: - A column in one table whose values can be matches to the primary key of another table is called as Foreign Key.

3) What is Candidate Key?
Ans: - Any column or attribute that uniquely identifies a row in a table is a candidate for the primary key such as attribute or column is called as Candidate Key.

4) What is Alternate Key?
Ans: - Any column or attribute that is a candidate for the primary key but not the primary key is called as the Alternate Key.

5) What is Composite Key?
Ans:- When a Key that uniquely identifies the rows of the table is made up of more than one attribute is called as Composite Key.

No comments:

Post a Comment