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
Why does this query return 0?
Explain about network model?
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?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain the process of the user request and data generating?
What is a database development?
How is data stored in dbms?
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?
What are the three basic rules which are to be followed for the relational model of the database?
What are the constraints on severity level in raiseerror?
Which data type cannot be used as a parameter in a udf?
Where is dbms used?
Who are end users in dbms?
How to generate OIDS
Explain the rollup operator?