1.

A Key which is a set of one or more columns that can identify a record uniquely is called?(a) Natural key(b) Candidate key(c) Not Null key(d) Alternate keyThe question was asked in an interview for internship.I'm obligated to ask this question of Foreign, Candidate, Primary, Composite, Unique Keys topic in portion Planning Oracle Applications of Oracle

Answer» <html><body><p>Correct answer is (b) Candidate key<br/><br/>For explanation: A candidate key is a combination of attributes that can be uniquely used to <a href="https://interviewquestions.tuteehub.com/tag/identify-496703" style="font-weight:bold;" target="_blank" title="Click to know more about IDENTIFY">IDENTIFY</a> a database <a href="https://interviewquestions.tuteehub.com/tag/record-1180336" style="font-weight:bold;" target="_blank" title="Click to know more about RECORD">RECORD</a> without any extraneous data. Each table may have one 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>. One of these candidate keys is selected as the table <a href="https://interviewquestions.tuteehub.com/tag/primary-1165403" style="font-weight:bold;" target="_blank" title="Click to know more about PRIMARY">PRIMARY</a> key.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions