Define candidate key, alternate key, composite key?
Answer Posted / ramesh
A composite Key can be either Primay or Unique Key
More then One Key columns are said to be composite keys
Candidate Key(Primary Key) is a Key which Maintains the Row
Uniue .Can be defined based on the Entity
Alternate Key or Unique Key is similar to PK ,except it
accepts null Values .So that the records can still be
entered submitting null values to this attribute.
Is This Answer Correct ? | 151 Yes | 207 No |
Post New Answer View All Answers
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
What is data modeling with example?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain about query and reporting.
How would you design a database for an online site, which would average a million hits a day?
Write short notes on manual refreshes.
Explain about the database management systems.
What is normalization? Explain different levels of normalization?
Explain about relational operator join?
Explain about the relational database?
Explain about a primary key?
What is dbms and its application?
Can an extended stored procedure be called from inside a user-defined function?
What is the physical representation for a many-to-many relationship?
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?