1.

Which of the following statements is not correct?(a) The primary key must be unique for a given table(b) Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required(c) Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required(d) Most databases allow multiple records that are identicalI got this question during a job interview.This key question is from Foreign, Candidate, Primary, Composite, Unique Keys topic in portion Planning Oracle Applications of Oracle

Answer» <html><body><p>Correct choice is (b) Specifying a zero (0) for the <a href="https://interviewquestions.tuteehub.com/tag/lower-1080637" style="font-weight:bold;" target="_blank" title="Click to know more about LOWER">LOWER</a> bound for the association multiplicity on a class diagram <a href="https://interviewquestions.tuteehub.com/tag/indicates-1041501" style="font-weight:bold;" target="_blank" title="Click to know more about INDICATES">INDICATES</a> that the item is required<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A foreign key is a column that references a column (most often the primary key) of another table. The purpose of the foreign key is to ensure referential integrity of the data. In other <a href="https://interviewquestions.tuteehub.com/tag/words-25841" style="font-weight:bold;" target="_blank" title="Click to know more about WORDS">WORDS</a>, only values that are supposed to appear in the database are permitted.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions