BCNF is stricter than 3NF 2) Lossless, dependency-preserving decomposition into 3NF is always possible 3) Lossless, dependency-preserving decomposition into BCNF is always possible 4) Any relation with two attributes is in BCNF
Asked in RPSC 23Feb 2016Question Paper for VicePrincipal/Superintendent ITI Screening Test 2012(Computer Science)VICE PRINCIPAL/SUPDT. ITI - 2012
Show answer
Answer: C. Lossless, dependency-preserving decomposition into BCNF is always possible
More RPSC Prelims previous year questions questions
- Ques #: 62 The following functional dependencies are given: AB->CD , AF-> D, DE-> F, C->G, F-> E, G-> A Which one of the following options is false? 1) {CF}+ = {ACDEFG} 2) {BG}+ = {ABCDG} 3) {AF}+ = {ACDEFG} 4) {AB}+ = {ABCDFG}
- Ques #: 63 Fifth normal form is also called:- 1) Protect-join normal form 2) Process-join normal form 3) Project-join normal form 4) None of these
- Ques #: 64 Which of the following statement is correct :- 1) HTML have open and close ended tags 2) HTML have only open ended tags 3) HTML have only close ended tags 4) HTML neither have open nor close ended tags
- 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)
- Ques #: 66 Consider the following two schedules: S1: r3(X); r1(X); r1(Z); r2(Z); r3(Y); W1(X); C1; W3(Y); C3; r2(Y); W2(Y); W2(Z); C2; S2: r1(Z); r2(Z); r3(Y); r1(X); r3(X); W1(X); W3(Y); r2(Y); W2(Y); W2(Z); C1; C2; C3; Which of the following is true regarding above schedules? 1) S1: Conflict serializable, recoverable and cascadeless S2: Conflict serializable, neither recoverable nor cascadeless 2) S1: Conflict serializable, recoverable and cascadeless S2: Not conflict serializable, recoverable but not cascadeless 3) S1: Conflict serializable but neither recoverable nor cascadeless S2: Not conflict serializable 4) S1: Not conflict serializable but is recoverable and cascadeless S2: Conflict serializable and cascadeless but not recoverable
- Ques #: 67 "Spiral model is an incremental model". How long the spiral will continue? 1) Until the system (or software) retires 2) Up to β-testing 3) When rest analysis is completed 4) None of these
- Ques #: 68 What does CASE Tool mean:- 1) Tools used for analysis and design only 2) Any computer based tool for software planning , development and evolution 3) Any tool used for case study only 4) Tools for testing the software
- Ques #: 69 Which of the following is an advantage of waterfall model ? 1) The model assume stage rigidity 2) Enforced disciplined approach 3) The model makes no allowance for prototyping 4) Relegating maintenance is limited to minor changes