Define candidate key, alternate key, composite key?
Answer Posted / viresh rajput
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:-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:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
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?
What are the constraints on severity level in raiseerror?
How long can an error message be in raiseerror function?
Explain about relational database management systems?
How to combine two function together?
What are the key features of dbms?
Where is dbms used?
Explain about normal forms?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is database design and development?
I have a few records all are same structures data, I want to store data in multiple targets how
How you can make a parameterized view?
What is DB Development software?
What are the 18 schemas?