Define candidate key, alternate key, composite key?

Answer Posted / zulfiqar ali

ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.

2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to combine two function together?

1666


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

598


Explain about query and reporting.

1694


Explain about the storage and physical database design?

535


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

596






Explain about relational database management systems?

574


Explain about normal forms?

606


Can an extended stored procedure be called from inside a user-defined function?

618


How to use online Backups?

1734


Who are naive users?

612


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

568


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

566


State the acid rules?

688


What are the three types of database design?

549


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

1825