Time Left - 20:00 mins

GATE CS : Databases Champion Quiz 2

Attempt now to get your rank among 590 students!

Question 1

Which among the following process involved in arrangement of data in logical sequence?

Question 2

Which of the following scenarios may lead to an irrecoverable error in a database system?

Question 3

Consider a schema R(A,B,C,D) and functional dependencies A →B and C →D. Then the decomposition of R into R₁ (AB) and R₂(CD) is

Question 4

Which of the following is TRUE?

Question 5

Which one of the following statements about normal forms is FALSE?

Question 6

Which of the following relational calculus expressions is not safe?

Question 7

Consider the following relational schemes for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
with the following functional dependencies:
I. Title Author →Catalog_no
II. Catalog_no →Title Author Publisher Year
III. Publisher Title Year →Price
Assume {Author, Title} is the key for both schemes.
Which of the following statements is true?

Question 8

Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold : {A → B, BC → D, E → C, D → A}. What are the candidate keys of R?

Question 9

Relation R is decomposed using a set of functional dependencies, F, and relation S is decomposed using another set of functional dependencies, G. One decomposition is definitely BCNF, and the other is definitely. 3NF, but it is not known which is which. To make a guaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closures of F and G are available).

Question 10

R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition?

590 attempts
1 upvote
20 comments

Tags :

GATE & PSU CS Databases

Jul 5GATE & PSU CS