NIELIT Scientific Assistant Day: 23 Database Quiz-2

Attempt now to get your rank among 805 students!

Question 1

From the following instance of a relation schema R(A,B,C), we can conclude that:

• AA functionally determines B and B functionally determines C
• BA functionally determines B and B does not functionally determines C
• CB does not functionally determines C
• DA does not functionally determines B and B does not functionally determines

Question 2

Give the expression for N_f in terms of n.

• An
• Bn^n
• C2n
• DNone of the above

Question 3

Consider the following schema
student (Sid, C name)
Which of the following finds the students who are enrolled in both GATE and IES.

• A
• B
• CBoth (a) and (b).
• DNone of these.
  ­

Question 4

Which command undo all the updates performed by the SQL in the transaction?

• ARollback
• BCommit
• CTruncate
• DDelete

Question 5

Which of the following is true?

• AWait-die scheme of deadlock prevention strategy is non preemptive
• BWound-wait scheme of deadlock prevention strategy is preemptive
• CBoth a and b
• DNeither a nor b

• 805 attempts
• 5 upvotes
• 22 comments