
DBMS- NORMALIZATION
Authored by Mani CS
Computers
University
Used 7+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Dependent
Normal
Candidate
Both Normal and Candidate
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
A -> B
A -> C
A -> (B,C)
(B,C) -> A
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Transitive Dependency
Insertion Anomaly
Referential Integrity Constraint
Normal Form
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Every constraint on the table is a logical consequence of the table’s
Fourth normal form
Fifth normal form
Domain/key normal form
None of the Mentioned
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
Candidate
Join
Functional
None of the Mentioned
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
Accupressure
Decomposition
Precomposition
Both Decomposition and Precomposition
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A ___ is normalized after it has been organized.
Table
Database
Row
Column
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
40 questions
PAS SISTEM KOMPUTER X
Quiz
•
1st Grade - University
40 questions
HTML CSS
Quiz
•
University
40 questions
Тестирование MS Word
Quiz
•
University
44 questions
20703 - SCCM
Quiz
•
University
35 questions
Evaluasi Ms. Word [Divisi Office-UKM CC]
Quiz
•
7th Grade - University
40 questions
quiz based on web design
Quiz
•
University
40 questions
Szkolenie cz.1 Podstawy języka SQL
Quiz
•
University
35 questions
HTML 1
Quiz
•
University
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade