Question 1

To count the number of rows in a table,use the SQL construct COUNT(ROWS).

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

When accessing table structure,how do you determine the number and types of columns in a table?

Accepted Answer

To determine the number and types of how

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Anomalies caused by functional dependencies can be eliminated by putting tables into ________.

Accepted Answer

A) 1NF 
B) 2NF 
C) 3NF 
D) BCNF 
E) 4NF 
A) 1NF 
B) 2NF 
C) 3NF 
D) BCNF 
E) 4NF

Question 7

The second step in assessing table structure includes ________.

Accepted Answer

A) counting rows 
B) examining columns 
C) examining data values 
D) A and B 
E) B and C 
A) counting rows 
B) examining columns 
C) examining data values 
D) A and B 
E) B and C

Question 8

The third step in assessing table structure is to check the validity of presumed referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

For a number of reasons,________ is not often an advantage for a read-only database.

Accepted Answer

A) updating 
B) normalization 
C) denormalization 
D) A and B 
E) B and C 
A) updating 
B) normalization 
C) denormalization 
D) A and B 
E) B and C

Question 15

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

Accepted Answer

The multivalue,multicolumn problem occur

Question 16

What are the advantages and disadvantages of normalization?

Accepted Answer

The advantages of normalization are that

Question 17

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 18

During the second step of 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 19

Normalization eliminates modification anomalies and data duplication.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) multivalued dependencies 
B) functional dependencies 
C) foreign keys 
D) A and B 
E) A,B,and C 
A) multivalued dependencies 
B) functional dependencies 
C) foreign keys 
D) A and B 
E) A,B,and C

Exam 4: Database Design Using Normalization

To count the number of rows in a table,use the SQL construct COUNT(ROWS).

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.

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

When accessing table structure,how do you determine the number and types of columns in a table?

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

Anomalies caused by functional dependencies can be eliminated by putting tables into ________.

The second step in assessing table structure includes ________.

The third step in assessing table structure is to check the validity of presumed referential integrity constraints.

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

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

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

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

An advantage of denormalization is ________.

For a number of reasons,________ is not often an advantage for a read-only database.

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

What are the advantages and disadvantages of normalization?

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

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

Normalization eliminates modification anomalies and data duplication.

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters