Database Design Using Normalization - True or False Online Exam Quiz
Database Design Using Normalization - True or False GK Quiz. Question and Answers related to Database Design Using Normalization - True or False. MCQ (Multiple Choice Questions with answers about Database Design Using Normalization - True or False
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
Options
A : True
B : False
C : -
D : -
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
Options
A : True
B : False
C : -
D : -
When building a database from an existing set of tables, we still need to consider normalization principles.
Options
A : True
B : False
C : -
D : -
We have normalized a table into BCNF if all candidate keys are determinants.
Options
A : True
B : False
C : -
D : -
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
Options
A : True
B : False
C : -
D : -
One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
Options
A : True
B : False
C : -
D : -
In all cases, normalization into BCNF is desirable.
Options
A : True
B : False
C : -
D : -
Denormalized tables are in BCNF.
Options
A : True
B : False
C : -
D : -
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
Options
A : True
B : False
C : -
D : -
Proper normalization eliminates duplicated data.
Options
A : True
B : False
C : -
D : -
Advanced SQL - General Questions more Online Exam Quiz
Data and Database Administration - True or False
Database Processing for BIS - True or False
Database Redesign - True or False
Data Modeling with ER Model - True or False