1.

A Foreign key is combined with a foreign key creates(a) Parent child relationship between the tables that connect them(b) Many-Many relationship between the tables that connect them(c) Network model between the tables that connect them(d) None of the MentionedThe question was posed to me in semester exam.The doubt is from Foreign, Candidate, Primary, Composite, Unique Keys topic in division Planning Oracle Applications of Oracle

Answer» <html><body><p>Correct answer is (a) Parent child relationship between the tables that connect them<br/><br/>To explain I would <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: In a <a href="https://interviewquestions.tuteehub.com/tag/foreign-995515" style="font-weight:bold;" target="_blank" title="Click to know more about FOREIGN">FOREIGN</a> key reference, a link is created between two tables when the column or columns that hold the primary key <a href="https://interviewquestions.tuteehub.com/tag/value-1442530" style="font-weight:bold;" target="_blank" title="Click to know more about VALUE">VALUE</a> for one table are referenced by the column or columns in <a href="https://interviewquestions.tuteehub.com/tag/another-876628" style="font-weight:bold;" target="_blank" title="Click to know more about ANOTHER">ANOTHER</a> table. This column becomes a foreign key in the second table.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions