Define candidate key, alternate key, composite key?
Answer Posted / piyush kathayat
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
Is This Answer Correct ? | 587 Yes | 62 No |
Post New Answer View All Answers
How to use online Backups?
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 is an application role and explain a scenario when you would use one?
How to customize error conditions.
What is dbms explain in brief?
What is DB Development software?
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.
What is the maximum length of an extended property?
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?
How to replace not in with not exist?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
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?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to read and create .LDC data files which are used by linguatic dictionary.
explain detail about ftp in datastage?