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

How to replace not in with not exist?

1470


Explain about relational database management systems?

572


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).

1789


What are data modelling techniques?

529


How can you fix a poorly performing query?

624






How to generate OIDS

1666


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

550


What is DB Development software?

1619


Where is dbms used?

625


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?

580


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

564


What are the key features of dbms?

574


How to customize error conditions.

1706


Explain the cube operator?

607


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

593