Define candidate key, alternate key, composite key?
Answer Posted / raju
candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be a primary key.
alternate key:-In the candidate key the key which is not
primary key is the alternate key.
composite key:- A key formed bythe combination of 2 or more
columns is the composite key.
| Is This Answer Correct ? | 52 Yes | 24 No |
Post New Answer View All Answers
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).
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are data modelling techniques?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the role of indexing in databases?
Explain about query and reporting.
In which database can extended stored procedures be added?
Which four data types cannot be used as a return type from a user-defined function?
How can you fix a poorly performing query?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How to use online Backups?
What is database design and development?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the three basic rules which are to be followed for the relational model of the database?
What are the 18 schemas?