Define candidate key, alternate key, composite key?
Answer Posted / garima sinha
candidate keys are those key which can be treated as
primary key when required.
composite key is made up of more than on key and treated as
primary key.
Alternate key (or secondary key) is any candidate key which
is not selected to be the primary key.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
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?
Explain about post-relational databases?
Explain about the relational database?
Explain about a primary key?
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 are data modelling techniques?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain what a database is?
Which four data types cannot be used as a return type from a user-defined function?
How can I detect whether a given connection is blocked?
I have a few records all are same structures data, I want to store data in multiple targets how
What are the 18 schemas?
Which data type cannot be used as a parameter in a udf?
Explain about relational database management systems?