RRB JE (IT) : DBMS fundamentals

Attempt now to get your rank among 210 students!

Question 1

Consider the relation R(ABCD) with FD set F={AB->CD,C->A,D->B}. Which of the following is false?

• AC->A is a partial dependency
• BC->A is a transitive dependency
• CD->B is a partial dependency
• DNone of these.

Question 2

R{a,b,c} and S{x,y,z} are two relations in which x is a foreign key referring to the primary key of relation R.
Consider the following operations. Which among these operations may violate the referential integrity constraint?

• AInsert into R
• BDelete from R
• CDelete from S
• DNone of these

Question 3

Consider the following relation R

Then identify the incorrect statement about relation R
I. The relation R has two overlapping candidate keys
II. The relation R is in 3NF
III. The relation R is in BCNF
IV. The relation R has a disadvantage of repetition of data

• AI & IV 
• BIII
• CII
• DII & III

Question 4

Consider the following statements
(i) SQL’s aggregation can’t be expressed in relational algebra
(ii) SQL’s grouping construct can be expressed in relation algebra.
Which of the following is correct?

• AOnly (i) is true
• BOnly (ii) is true
• CBoth (i) and (ii) are true
• DNone of these

Question 5

R is relationship with 1 : 1 cardinality, 30% participation at E₁ end, 70% participation at E₂ end. Which is the best possible design?

• AE₁ and E₂ kept separate with foreign key at E₁ end
• BE₁ and E₂ kept separate with foreign key at E₂ end
• CE₁ and E₂ kept separate with foreign key at E₁ as well as E₂
• DE₁ and E₂ merges into a single table with no foreign key

• 210 attempts
• 0 upvotes
• 1 comment