
Database Normalization Quiz Part2
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Comprehensive Viva
Used 2+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consider the relation R(A, B, C, D, E) and the functional dependency set F={AB→C, B→D, C→E }. What is the highest normal form of the relation R ?
1NF
2NF
3NF
BCNF
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consider the relation R (A, B, C, D, E) and the functional dependency set F = {AB→CD, ABC→E, C→A}. How many candidate keys are possible for the relation R ?
1
2
3
4
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consider a relation R(A, B, C, D, E) and a set of all FDs that hold on R as given below: {A → BC, CD → E, B → D, E → A} Choose the correct option:
R is in 1NF, not in 2NF
R is in 2NF, not in 3NF
R is in 3NF, not in BCNF
R is in BCNF
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Consider the following two sets of functional dependencies: F = {A → C, AC → D, E → AD, E → H} G = {A → CD, E → AH} Choose the correct option:
only F covers G
only G covers F
F and G are equivalent
None of the above
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consider the following schedule S.
S: R1(X); W1(X); R2(X); W2(X); R1(Y); R2(Y);
Which of the following is a non-conflicting pair of operations in the schedule S?
R1(X); W1(X);
W1(X); R2(X);
W1(X); W2(X);
R1(X); W2(X);
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To be conflict serializable, all transactions should follow _______
Binary locking
Two phase locking
Binary Locking with wait-for graph
None of these
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a type of database model?
Relational model
Network model
Hierarchical model
Object-oriented model
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Data Structures Quiz
Quiz
•
University
18 questions
Строка CMD
Quiz
•
University
19 questions
SQL Quiz
Quiz
•
University
20 questions
UI/UX Design Midterm Exam
Quiz
•
University
20 questions
IT Essential UIUX Chapter 03 (Typography)
Quiz
•
University
15 questions
After Effects Hotkeys
Quiz
•
University - Professi...
20 questions
KSAks 2023
Quiz
•
University
20 questions
Ch.8 - Introducing Python
Quiz
•
6th Grade - Professio...
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
20 questions
christmas songs
Quiz
•
KG - University
20 questions
Holiday Trivia
Quiz
•
9th Grade - University
15 questions
Holiday Movies
Quiz
•
University
14 questions
Christmas Trivia
Quiz
•
3rd Grade - University
20 questions
Christmas Trivia
Quiz
•
University
8 questions
5th, Unit 4, Lesson 8
Lesson
•
KG - Professional Dev...
20 questions
Disney Trivia
Quiz
•
University
