DBMS |Gate-2013| Previous Year Questions| Set-8

Set-15 GATE-2006 DBMS

DBMS |Gate-2013| Database Management System

1. An index is clustered, if : [GATE – 2013]

a. it is on a set of fields that form a candidate key.
b. it is on a set of fields that include the primary key.
c. the data records of the file are organized in the same order as the data entries of the index.
d. the data records of the file are organized not in the same order as the data entries of the index.

Answer : c)


2. Consider the following releation schema

Students (rollno: integer, sname: string)
Courses (courseno: integer, cname: string )
Registration (rollno : integer, courseno : integer,percent : real)
Which of the following queries are equivalent to this query in English?

“Find the distinct names of all students who score more than 90% in the courses numbered 107”. [GATE – 2013]

a. I, II, III and IV
b. I, II and III only
c. I, II and IV only
d. II, III and IV only

Answer : a)


3. Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values.

F= {CH→G,A→BC,B→CFH, E→A,F→EG} is a set of a functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.

How many candidate keys does the relation R have? [GATE – 2013]

a. 3
b. 4
c. 5
d. 6

Answer : b)


4. Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values.

F= {CH→G,A→BC,B→CFH, E→A,F→EG} is a set of functional dependiences (FDs) so that F+ is exactly the set  of FDs that hold for R. The relation R is: [GATE – 2013]

a. in 1NF, but not in 2NF.
b. in 2NF, but not in 3NF.
c. in 3NF, but not in BCNF.
d. in BCNF.

Answer : a)
DBMS |Gate-2013|


Back to GATE-HOME


Spread the love

Leave a Comment

Your email address will not be published. Required fields are marked *