Define candidate key, alternate key, composite key?

Answer Posted / pratik bachchuwar

candidate key: it is the no of uniquely identified column
(or attribute) in a table.


alternate key: it is simply defined as the (no of candidate
key) - (no of primary key in a table).




composite key: it is the group of primary or uniquely
identified key which again unique in other table.

Is This Answer Correct ?    12 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the key features of dbms?

767


What is an application role and explain a scenario when you would use one?

769


Explain about the relational database?

821


Explain about relational operator join?

804


How to read and create .LDC data files which are used by linguatic dictionary.

2278


Explain about a primary key?

755


How to use online Backups?

1982


Explain about the storage and physical database design?

714


Explain what a database is?

810


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3724


What is dbms and its application?

757


explain detail about ftp in datastage?

2013


Write the fastest query to find out how many rows exist in a table?

890


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2003


What are the three basic rules which are to be followed for the relational model of the database?

763