Database Management System Mock Test 4

10%

Question 1 of 10

Empdt1(empcode, name, street, city, state, pincode).

For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

1 NF only

2 NF and hence also in 1 NF

3NF and hence also in 2NF and 1NF

BCNF and hence also in 3NF, 2NF and 1NF

Question 1 of 10

Question 2 of 10

Class (course id, title, dept name, credits, sec id, semester, year, building, room number, capacity, time slot id)
The set of functional dependencies that we require to hold on class are:
course id->title, dept name, credits
building, room number->capacity
course id, sec id, semester, year->building, room number, time slot id
A candidate key for this schema is {course id, sec id, semester, year}

Consider the above conditions. Which of the following relation holds?

Title-> dept name, credits

Course id-> title, dept name, credits

Dept name-> credits

Cannot be determined

Question 2 of 10

Question 3 of 10

3. Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Proportional to the size of F+

Zero

More than zero but less than that of an equivalent 3NF decomposition

Indeterminate

Question 3 of 10

Question 4 of 10

4. A domain is ______ if elements of the domain are considered to be indivisible units.

Subset

Substructure

Atomic

Subatomic

Question 4 of 10

Question 5 of 10

5. If a relation is in BCNF, then it is also in

2 NF

3 NF

All of the mentioned

1 NF

Question 5 of 10

Question 6 of 10

6. In the __________ normal form, a composite attribute is converted to individual attributes.

Second

First

Third

Fourth

Question 6 of 10

Question 7 of 10

7. The term for information that describes what type of data is available in a database is:

Index data

data repository

Data dictionary

Metadata

Question 7 of 10

Question 8 of 10

8. A dependency exist between two columns when

The table is in 3NF

Knowing the value in one column determines the value stored in another column

Together they constitute a foreign key

Together they constitute a composite key for the table

Question 8 of 10

Question 9 of 10

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

A->B, B->C, C->D

AB->C, C->AD

A->BCD

A->B, B->CD

Question 9 of 10

Question 10 of 10

10. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

Relation

Attribute

Value

Entity

Question 10 of 10