Define candidate key, alternate key, composite key?
Answer Posted / zulfiqar ali
ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.
2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain about post-relational databases?
fact table and dimension table containg one to many relationship or many to one relastionship
What is the physical representation for a many-to-many relationship?
Explain about the relational database?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How would you design a database for an online site, which would average a million hits a day?
How to combine two function together?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
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
Explain the role of indexing in databases?
What are the types of database model?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is the database development process?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
How to use timestamp datatypes