Question 1

An inconsistent values problem is created when different users have coded the same data entries differently.

Accepted Answer

A) True 
 B)False

Question 2

Normalization eliminates modification anomalies and data duplication.

Accepted Answer

A) True 
 B)False

Question 3

When examining data values as a part of assessing table structure,you should try to determine functional dependencies.

Accepted Answer

A) True 
 B)False

Question 4

To determine the number and type of columns in a table,use the SQL construct COUNT(*).

Accepted Answer

A) True 
 B)False

Question 5

A null value can indicate which of the following conditions?

Accepted Answer

A) The value is inappropriate. 
B) The value is appropriate but unknown. 
C) The value is appropriate and known,but not entered into the database. 
D) All of A,B or C are correct. 
E) None of the above is correct. 
A) The value is inappropriate. 
B) The value is appropriate but unknown. 
C) The value is appropriate and known,but not entered into the database. 
D) All of A,B or C are correct. 
E) None of the above is correct.

Question 6

To eliminate multivalued dependencies,normalize your tables so that they are all in BCNF.

Accepted Answer

A) True 
 B)False

Question 7

During the second step of the assessing table structure,you are trying to determine ________.

Accepted Answer

A) primary keys 
B) candidate keys 
C) foreign keys 
D) A and B 
E) A,B and C 
A) primary keys 
B) candidate keys 
C) foreign keys 
D) A and B 
E) A,B and C

Question 8

An advantage of denormalization is ________.

Accepted Answer

A) faster updating 
B) faster querying 
C) less complex SQL in application code 
D) A and B 
E) B and C 
A) faster updating 
B) faster querying 
C) less complex SQL in application code 
D) A and B 
E) B and C

Question 9

A null value in a column may indicate that there is no appropriate value for that attribute.

Accepted Answer

A) True 
 B)False

Question 10

The problem with a general-purpose remarks column is that the data it contains are likely to be verbal,inconsistent and stored in a verbose manner.

Accepted Answer

A) True 
 B)False

Question 11

Denormalization is the process of joining previously normalized tables back together.

Accepted Answer

A) True 
 B)False

Question 12

When examining data values as a part of assessing table structure,you should try to determine the table's primary key.

Accepted Answer

A) True 
 B)False

Question 13

When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys and any foreign keys.

Accepted Answer

A) True 
 B)False

Question 14

The problem of misspelled data entries is an entirely different problem than the inconsistent values problem.

Accepted Answer

A) True 
 B)False

Question 15

What are general-purpose remarks columns,and why are they a problem?

Accepted Answer

General-purpose remarks columns are colu

Question 16

The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.

Accepted Answer

A) True 
 B)False

Question 17

Read-only databases seldom use more than one copy of a set of same data.

Accepted Answer

A) True 
 B)False

Question 18

A missing value is called a(n)________.

Accepted Answer

A) empty value 
B) null value 
C) missing value 
D) Any of A,B or C can be used. 
E) None of the above is correct. 
A) empty value 
B) null value 
C) missing value 
D) Any of A,B or C can be used. 
E) None of the above is correct.

Question 19

The SQL keyword TOP ________.

Accepted Answer

A) limits the number of columns retrieved from a table 
B) limits the number of rows retrieved from a table 
C) limits the number of tables retrieved from a database 
D) A and C 
E) B and C 
A) limits the number of columns retrieved from a table 
B) limits the number of rows retrieved from a table 
C) limits the number of tables retrieved from a database 
D) A and C 
E) B and C

Question 20

________ is the process of joining two or more tables and storing the result as a single table.

Accepted Answer

A) Querying 
B) Normalization 
C) Denormalization 
D) A and B 
E) B and C 
A) Querying 
B) Normalization 
C) Denormalization 
D) A and B 
E) B and C

Exam 4: Database Design Using Normalization

An inconsistent values problem is created when different users have coded the same data entries differently.

Normalization eliminates modification anomalies and data duplication.

When examining data values as a part of assessing table structure,you should try to determine functional dependencies.

To determine the number and type of columns in a table,use the SQL construct COUNT(*).

A null value can indicate which of the following conditions?

To eliminate multivalued dependencies,normalize your tables so that they are all in BCNF.

During the second step of the assessing table structure,you are trying to determine ________.

An advantage of denormalization is ________.

A null value in a column may indicate that there is no appropriate value for that attribute.

The problem with a general-purpose remarks column is that the data it contains are likely to be verbal,inconsistent and stored in a verbose manner.

Denormalization is the process of joining previously normalized tables back together.

When examining data values as a part of assessing table structure,you should try to determine the table's primary key.

When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys and any foreign keys.

The problem of misspelled data entries is an entirely different problem than the inconsistent values problem.

What are general-purpose remarks columns,and why are they a problem?

The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.

Read-only databases seldom use more than one copy of a set of same data.

A missing value is called a(n)________.

The SQL keyword TOP ________.

________ is the process of joining two or more tables and storing the result as a single table.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters