Define candidate key, alternate key, composite key?
Answer Posted / divya
candidate key: is a column in a table which has thhe ability
to become a primary key.
alternate key:any of the candidate key that is not part of
the primary key.
| Is This Answer Correct ? | 34 Yes | 33 No |
Post New Answer View All Answers
How would you design a database for an online site, which would average a million hits a day?
Where is dbms used?
Explain about the hierarchical model of the database?
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?
Explain about the relational database?
How you can make a parameterized view?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain the role of indexing in databases?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
explain detail about ftp in datastage?
Who are end users in dbms?
Explain about query and reporting.
Who are naive users?
Explain about relational operator join?
fact table and dimension table containg one to many relationship or many to one relastionship