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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
