Define candidate key, alternate key, composite key?
Answer Posted / koteswararao bora
candidate key:the minimum set of attributes which uniquely
identifies the touples in a table .
primary key:any candidate key choosen by the developer is
called primary key.
composite key: a candidate key which have more than one
attribute is called composite key.
alternate key: a candidate key other than primary key
is called alternate key.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which database can extended stored procedures be added?
Explain the role of indexing in databases?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
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).
What are the key features of dbms?
How to use timestamp datatypes
What is the physical representation for a many-to-many relationship?
Which data type cannot be used as a parameter in a udf?
What is dbms and its application?
What is database design and development?
explain detail about ftp in datastage?
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?