Q.1

Denormalized tables are in BCNF.

  • True
  • False
Q.2

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

  • True
  • False
Q.3

Read-only databases are ________ updated.

  • always
  • commonly
  • seldom
  • never
Q.4

When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

  • first step.
  • second step.
  • third step.
  • fourth step.
Q.5

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.
Q.6

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.7

Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

  • advantage
  • disadvantage
  • either an advantage or disadvantage
  • neither an advantage nor disadvantage
Q.8

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

  • True
  • False
Q.9

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

  • True
  • False
Q.10

Proper normalization eliminates duplicated data.

  • True
  • False
Q.11

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

  • True
  • False
Q.12

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

  • True
  • False
Q.13

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.14

Creating a read-only database is a task that is ________ assigned to beginning database professionals.

  • always
  • commonly
  • seldom
  • never
Q.15

Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column 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.
Q.16

When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:

  • first step.
  • second step.
  • third step.
  • fourth step.
Q.17

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.18

Normalization requires programmers to write more complex SQL.

  • True
  • False
Q.19

Eliminating modification anomalies is a(n) ________ of normalization.

  • advantage
  • disadvantage
  • either an advantage or disadvantage
  • neither an advantage nor disadvantage
Q.20

Multivalued dependencies should ________ be eliminated.

  • always
  • commonly
  • seldom
  • never
0 h : 0 m : 1 s