Define candidate key, alternate key, composite key?
Answer Posted / pratik bachchuwar
candidate key: it is the no of uniquely identified column
(or attribute) in a table.
alternate key: it is simply defined as the (no of candidate
key) - (no of primary key in a table).
composite key: it is the group of primary or uniquely
identified key which again unique in other table.
Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
Explain about the relational database?
Explain about relational operator join?
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?
fact table and dimension table containg one to many relationship or many to one relastionship
What is the database development process?
What are the constraints on severity level in raiseerror?
What are data modelling techniques?
I have a few records all are same structures data, I want to store data in multiple targets how
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).
How you can make a parameterized view?
explain detail about ftp in datastage?
Explain about network model?
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?
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.