MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Database Design Using Normalization
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
True
False
Q.2
One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
True
False
Q.3
Normalization requires programmers to write more complex SQL.
True
False
Q.4
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
True
False
Q.5
When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
True
False
Q.6
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
True
False
Q.7
The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
True
False
Q.8
We use the SQL construct COUNT(*) to count the number of rows in a table.
True
False
Q.9
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.
True
False
Q.10
In all cases, normalization into BCNF is desirable.
True
False
Q.11
When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
True
False
Q.12
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
True
False
Q.13
Denormalized tables are in BCNF.
True
False
Q.14
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
True
False
Q.15
Proper normalization eliminates duplicated data.
True
False
Q.16
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.
True
False
Q.17
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
True
False
Q.18
Read-only databases are ________ updated.
always
commonly
seldom
never
Q.19
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
advantage
disadvantage
either an advantage or disadvantage
neither an advantage nor disadvantage
Q.20
Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page