1.

In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.(a) Candidate(b) Join(c) Functional(d) None of the MentionedI have been asked this question in examination.This is a very interesting question from Normalization in division Planning Oracle Applications of Oracle

Answer» <html><body><p>The correct answer is (a) Candidate<br/><br/>The explanation is: A candidate key is a column, or <a href="https://interviewquestions.tuteehub.com/tag/set-11758" style="font-weight:bold;" target="_blank" title="Click to know more about SET">SET</a> of columns, in a table that can uniquely identify any <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> record without referring to any other data. Each table <a href="https://interviewquestions.tuteehub.com/tag/may-557248" style="font-weight:bold;" target="_blank" title="Click to know more about MAY">MAY</a> have <a href="https://interviewquestions.tuteehub.com/tag/one-585732" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> or more candidate <a href="https://interviewquestions.tuteehub.com/tag/keys-15619" style="font-weight:bold;" target="_blank" title="Click to know more about KEYS">KEYS</a>.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions