True Or False

Question 1 :

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.


A). True
B). False
Answer : Option B

Question 2 :

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.


A). True
B). False
Answer : Option A

Question 3 :

When building a database from an existing set of tables, we still need to consider normalization principles.


A). True
B). False
Answer : Option A

Question 4 :

We have normalized a table into BCNF if all candidate keys are determinants.


A). True
B). False
Answer : Option B

Question 5 :

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.


A). True
B). False
Answer : Option B

Question 6 :

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.


A). True
B). False
Answer : Option B

Question 7 :

In all cases, normalization into BCNF is desirable.


A). True
B). False
Answer : Option B

Question 8 :

Denormalized tables are in BCNF.


A). True
B). False
Answer : Option B

Question 9 :

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.


A). True
B). False
Answer : Option A

Question 10 :

Proper normalization eliminates duplicated data.


A). True
B). False
Answer : Option B

Question 11 :

The design guidelines and priorities for read-only databases are different because read-only databases are never updated.


A). True
B). False
Answer : Option A

Question 12 :

The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.


A). True
B). False
Answer : Option A

Question 13 :

We use the SQL construct COUNT(*) to count the number of rows in a table.


A). True
B). False
Answer : Option A

Question 14 :

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.


A). True
B). False
Answer : Option B

Question 15 :

Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.


A). True
B). False
Answer : Option B

Question 16 :

One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.


A). True
B). False
Answer : Option A

Question 17 :

One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.


A). True
B). False
Answer : Option B

Question 18 :

Normalization requires programmers to write more complex SQL.


A). True
B). False
Answer : Option A

Question 19 :

One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.


A). True
B). False
Answer : Option A

Question 20 :

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.


A). True
B). False
Answer : Option B