Define candidate key, alternate key, composite key?

Answer Posted / divya lover

candidate key: is a column in a table which has thhe ability
to become a primary key.

alternate key:any of the candidate key that is not part of
the primary key. cheating of my lover divya......

Is This Answer Correct ?    18 Yes 34 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the process of the user request and data generating?

651


What are the constraints on severity level in raiseerror?

582


On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

566


Explain about network model?

585


How to use online Backups?

1728






How would you design a database for an online site, which would average a million hits a day?

578


What are data modelling techniques?

526


What are the three types of database design?

543


fact table and dimension table containg one to many relationship or many to one relastionship

2078


Explain the role of indexing in databases?

642


State the acid rules?

682


Explain about relational operator join?

615


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

576


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1786


Explain about the relational database?

608