Ques #: 65 Consider a relation R = {M,N,O,P,Q,R,S,...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
RPSC Prelims previous year questions

Ques #: 65 Consider a relation R = {M,N,O,P,Q,R,S,T} with the following set of dependencies MN -> O M -> PQ N -> R R -> ST Next consider the following set of decompositions for the relational schema R: D1 = {R1, R2, R3, R4} ; R1 = {M,N,O} , R2 = {M,P,Q} , R3 = {N,R} , R4 = {R,S,T} D2 = {R1, R2, R3, R4} ; R1 = {M,N,O,P} , R2 = {P,Q} , R3 = {N,R} , R4 = {R,S,T} Which of the above decomposition(s) has/have lossless join property ? 1)

Asked in RPSC 23Feb 2016Question Paper for VicePrincipal/Superintendent ITI Screening Test 2012(Computer Science)VICE PRINCIPAL/SUPDT. ITI - 2012

  1. D1 only
  2. D2 only
  3. Both D1 and D2
  4. Neither D1 nor D2
Show answer

Answer: A. D1 only

More RPSC Prelims previous year questions questions

All 8,445 RPSC Prelims previous year questions questions →