1.

A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.(a) Dependent(b) Normal(c) Candidate(d) Both Normal and CandidateThis question was addressed to me in an interview for internship.This interesting question is from Normalization in chapter Planning Oracle Applications of Oracle

Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (c) Candidate<br/><br/>The explanation: A table is in Boyce-Codd normal <a href="https://interviewquestions.tuteehub.com/tag/form-996208" style="font-weight:bold;" target="_blank" title="Click to know more about FORM">FORM</a> (BCNF) if and only if it is in 3NF and every determinant is a candidate <a href="https://interviewquestions.tuteehub.com/tag/key-11608" style="font-weight:bold;" target="_blank" title="Click to know more about KEY">KEY</a>.</body></html>


Discussion

No Comment Found

Related InterviewSolutions