Question 1

The SQL INSERT statement can be used to populate normalized tables.

Accepted Answer

A) True 
 B)False

Question 2

To count the number of rows in a table,use the SQL construct ________.

Accepted Answer

A) SELECT * 
B) SELECT TOP n * 
C) SELECT COUNT(TOP n) 
D) SELECT COUNT(*) 
E) SELECT COUNT * 
A) SELECT * 
B) SELECT TOP n * 
C) SELECT COUNT(TOP n) 
D) SELECT COUNT(*) 
E) SELECT COUNT *

Question 3

A defining requirement for BCNF is that every determinant must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 4

The standard sales order/line item pattern is a classic example of unneeded normalization.

Accepted Answer

A) True 
 B)False

Question 5

To limit the number of rows retrieved from a table,use the SQL TOP keyword.

Accepted Answer

A) True 
 B)False

Question 6

Normalization is an advantage for a read-only database.

Accepted Answer

A) True 
 B)False

Question 7

Relations are sometimes left unnormalized to improve performance.

Accepted Answer

A) True 
 B)False

Question 8

A null value in a column may indicate that there is an appropriate value for that attribute,but it is unknown.

Accepted Answer

A) True 
 B)False

Question 9

Denormalization reduces the complexity of the SQL statements needed in an application to read required data.

Accepted Answer

A) True 
 B)False

Question 10

What are null values,and why are they a problem?

Accepted Answer

A null value is a missing value,a value

Question 11

When examining data values as a part of assessing table structure,there is no need to try to determine foreign keys.

Accepted Answer

A) True 
 B)False

Question 12

What are the advantages and disadvantages of normalization?

Accepted Answer

The advantages of normalization are that

Question 13

To check for null values in a column in a table,use the SQL phrase ________.

Accepted Answer

A) IS 
B) IS NOT 
C) IS NULL 
D) COUNT(IS NOT) 
E) COUNT(IS NULL) 
A) IS 
B) IS NOT 
C) IS NULL 
D) COUNT(IS NOT) 
E) COUNT(IS NULL)

Question 14

A table designed to store PhoneNumber01,PhoneNumber02 and PhoneNumber03 contains ________.

Accepted Answer

A) the multivalued,multicolumn problem 
B) the inconsistent values problem 
C) the missing values problem 
D) the general-purpose remarks column problem 
E) None of the above is correct. 
A) the multivalued,multicolumn problem 
B) the inconsistent values problem 
C) the missing values problem 
D) the general-purpose remarks column problem 
E) None of the above is correct.

Question 15

The presence of one or more foreign keys in a relation prevents ________.

Accepted Answer

A) the elimination of modification anomalies 
B) the elimination of duplicated data 
C) more complex SQL for multitable subqueries and joins 
D) A and B 
E) A,B and C 
A) the elimination of modification anomalies 
B) the elimination of duplicated data 
C) more complex SQL for multitable subqueries and joins 
D) A and B 
E) A,B and C

Question 16

What is the multivalue,multicolumn problem,and why is it a problem?

Accepted Answer

The multivalue,multicolumn problem occur

Question 17

Unlike the anomalies from functional dependencies,the anomalies from ________ are so serious that they should always be eliminated.

Accepted Answer

A) ZIP codes 
B) sales orders and line items 
C) association patterns 
D) multivalued dependencies 
E) general purpose remarks columns 
A) ZIP codes 
B) sales orders and line items 
C) association patterns 
D) multivalued dependencies 
E) general purpose remarks columns

Question 18

The SQL keyword IS NULL can be used to ________.

Accepted Answer

A) count the number of columns in a table 
B) count the number of rows in a table 
C) count the number of null values in a column 
D) A and C 
E) B and C 
A) count the number of columns in a table 
B) count the number of rows in a table 
C) count the number of null values in a column 
D) A and C 
E) B and C

Question 19

Explain denormalization,and why it may be appropriate to denormalize a set of tables.

Accepted Answer

Denormalization is the process of taking

Question 20

The multivalued,multicolumn problem occurs when a set of columns are used to store data that should actually be in one column.

Accepted Answer

A) True 
 B)False

Exam 4: Database Design Using Normalization

The SQL INSERT statement can be used to populate normalized tables.

To count the number of rows in a table,use the SQL construct ________.

A defining requirement for BCNF is that every determinant must be a candidate key.

The standard sales order/line item pattern is a classic example of unneeded normalization.

To limit the number of rows retrieved from a table,use the SQL TOP keyword.

Normalization is an advantage for a read-only database.

Relations are sometimes left unnormalized to improve performance.

A null value in a column may indicate that there is an appropriate value for that attribute,but it is unknown.

Denormalization reduces the complexity of the SQL statements needed in an application to read required data.

What are null values,and why are they a problem?

When examining data values as a part of assessing table structure,there is no need to try to determine foreign keys.

What are the advantages and disadvantages of normalization?

To check for null values in a column in a table,use the SQL phrase ________.

A table designed to store PhoneNumber01,PhoneNumber02 and PhoneNumber03 contains ________.

The presence of one or more foreign keys in a relation prevents ________.

What is the multivalue,multicolumn problem,and why is it a problem?

Unlike the anomalies from functional dependencies,the anomalies from ________ are so serious that they should always be eliminated.

The SQL keyword IS NULL can be used to ________.

Explain denormalization,and why it may be appropriate to denormalize a set of tables.

The multivalued,multicolumn problem occurs when a set of columns are used to store data that should actually be in one column.

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