Database Design Using Normalization - General Questions Online Exam Quiz
Database Design Using Normalization - General Questions GK Quiz. Question and Answers related to Database Design Using Normalization - General Questions. MCQ (Multiple Choice Questions with answers about Database Design Using Normalization - General Questions
Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options
A : advantage
B : disadvantage
C : either an advantage or disadvantage
D : neither an advantage nor disadvantage
Eliminating modification anomalies is a(n) ________ of normalization.
Options
A : advantage
B : disadvantage
C : either an advantage or disadvantage
D : neither an advantage nor disadvantage
Multivalued dependencies should ________ be eliminated.
Options
A : always
B : commonly
C : seldom
D : never
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Options
A : first step.
B : second step.
C : third step.
D : fourth step.
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Options
A : The multivalue, multicolumn problem
B : The inconsistent values problem
C : The missing values problem
D : The general-purpose remarks column problem
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Options
A : first step.
B : second step.
C : third step.
D : fourth step.
Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Options
A : always
B : commonly
C : seldom
D : never
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Options
A : Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B : Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C : Three rows have the values Brown, NULL, and Blue in the same column.
D : One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Options
A : read-only
B : updateable
C : either a read-only or an updateable
D : None of the above is correct.
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Options
A : 1NF.
B : 2NF.
C : 3NF.
D : BCNF.
Advanced SQL - General Questions more Online Exam Quiz
Polymorphism - General Questions
Properties - General Questions
Structures - General Questions
Advanced SQL - General Questions
Data and Database Administration - General Questions
Database Processing for BIS - General Questions
Database Redesign - General Questions
Data Modeling with ER Model - General Questions