Databases MCQ with Answers

Databases MCQ with Answers

12) If a relation is in BCNF, then it is also in

Answer is:

All of the above

13) Consider the relation given below and ind the maximum normal form applicable to them
1. R(A, B) with productions { A --> B }
2. R(A, B) with productions { B --> A }
3 R(A, B) with productions {A —> B, B --> A }
4 R(A, B, C) with productions {A -->B, B --> A, AB --> C }

Answer is:

All are in BCNF

14) Consider the following
S1: Foreign key allows null values.
S2: Every binary tables is in BCNF
Which of the following is true

Answer is:

S1 is true

15) Consider the following functional dependencies in a database:
Date_of_Birth —> Age
Age —> Eligibility
Name —> Roll_number
Roll_number -> Name
Course_number ---> Course—> name
Course_number —> Instructor
(Roll number; Course_number) —> Grade
The relation (Roll_number; Name; Date_of birth, Age) is

Answer is:

in none of the above

16) The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, curseNo --> grade
RolINo, courseNo —> grade
name —> rollNo
rollNo —> name
The highest normal form ofthis relation scheme is:

Answer is:

3 NF