

InterviewSolution
Saved Bookmarks
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> | |