BARC CS 2018 Nuclear Quiz -2 ( DBMS)

Attempt now to get your rank among 592 students!

Question 1

Which of the following is true?

• AA relation in BCNF is always in 3NF.
• BA relation in 3NF is always in BCNF.
• CBCNF and 3NF are same.
• DA relation in BCNF is not in 3NF.

Question 2

There exists a construct which returns a value ‘true’ if the argument sub query is:

• Aempty
• Bnon-empty
• Cin error
• Dnone of the above

Question 3

The E-R model is expressed in term of
I. Entities
II. The relationship among entities.
III. The attributes of the entities.
IV. Functional relationship.

• AI, II
• BI, II, IV
• CII, II, IV
• DI, II, III

Question 4

Let and be two processes, R be the set of variables read from memory, and W be the set of variables written to memory. For the concurrent execution of two processes and which of the following conditions is not true?

• A
• B
• C
• D

Question 5

Third normal form is based on the concept of ______.

• AClosure Dependency
• BTransitive Dependency
• CNormal Dependency
• DFunctional Dependency

• 592 attempts
• 3 upvotes
• 21 comments