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
Which four data types cannot be used as a return type from a user-defined function?
State the acid rules?
How to combine two function together?
What is database design and development?
How to use timestamp datatypes
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?
What are data modelling techniques?
In which table collections errors are stored.
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.
How you can make a parameterized view?
What are the constraints on severity level in raiseerror?
How to replace not in with not exist?
Explain about the database management systems.
What is dbms and its application?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?