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
11

Databases MCQ with Answers

11) If every non-key attribute is functionally dependent primary key, then the relation will be in

First normal form

Second normal form

Third form

Fourth normal form

Answer is:

Second normal form

Databases MCQ with Answers

For more MCQ's Click Here

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

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:

2 NF

3 NF

BCNF

4 NF

Answer is:

3 NF

Databases MCQ with Answers

For more MCQ's Click Here

11) If every non-key attribute is functionally dependent primary key, then the relation will be in

Second normal form

Databases MCQ with Answers

Related Databases MCQ with Answers

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 }

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

S1 is true

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:

3 NF

Databases MCQ with Answers

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 }

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

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: