session 4 LNMIIT
Quiz
•
Professional Development
•
Professional Development
•
Hard
Rajeev Agarwa
Used 1+ times
FREE Resource
Enhance your content in a minute
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
If every non-key attribute is functionally dependent on the primary key, then the relation will be in ?
First Normal Form
Second Normal Form
Third Normal Form
No Normal Form
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following set of independencies is suitable for making a relation R(ABCD) to be in 3NF but not in BCNF
{AB→CD, A→C, D→B}
{AB→CD, C→DA}
{A→BCD, B→CD, C→D}
{AB→CD, C→A, D→B}
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Suppose a relation R is in 3NF. Then an FD: X→A is not valid on R, if
1 X is a proper subset of some key
2 X is not a proper subset of any key
3 X is a key
4 A is a part of some key
1 and 2 are correct
1 and 3 are correct
3 and 4 are correct
None is correct
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The reliability of a system with n redundant components each having a reliability of r is
1-(1-r)^n
1+(1-r)^n
1-(1+r)^n
(1+r)^n
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Choose the incorrect statement
A relation in 2NF must also be in 1NF
A relation in 3NF must also be in 2NF
A relation in 3NF must also be in BCNF
A relation in BCNF must also be in 3NF
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In database de-normalization is used for
Database backup
Deleting tables in normal form
Eliminating redundancy
Performance tuning
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A primary index refers to
primary key to relation
Foreign key of relation
Search key of on which relation is sorted
Degree of B+ tree
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
25 questions
STP Quiz 2024
Quiz
•
Professional Development
25 questions
Repaso
Quiz
•
Professional Development
25 questions
class ,objects,variables & methods
Quiz
•
Professional Development
25 questions
Customer Service
Quiz
•
University - Professi...
25 questions
Curriculum and Resources
Quiz
•
University - Professi...
25 questions
AUT203 Drivetrains Week 7 Quiz
Quiz
•
Professional Development
25 questions
Methods of Teaching English
Quiz
•
University - Professi...
25 questions
Quiz 1 - ITEDEV - Final
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
