www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
Engineering
Computer Science
Computer Science Set-1
Databases
10

Databases MCQ with Answers

10) A functional dependency of the form x —> y is trival if

y⊆x

y⊂x

x⊂y

x⊂y and y⊂x

Answer is:

y⊆x

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

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

1 NF

2 NF

3 NF

All of the above

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 }

1, 2 and 3 are in 3NF and 4 is in BCNF

1 and 2 are in BCNF and 3 and 4 are in 3NF

All are in 3NF

All are in BCNF

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

Both S1 and S2 are true

S1 is true

S2 is true

None of these

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

in second normal form but not in third normal form

in third normal form but not in BCNF

in BCNF

in none of the above

Answer is:

in none of the above

Databases MCQ with Answers

For more MCQ's Click Here