Question 1

Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.

Accepted Answer

A) True 
 B)False

Question 2

A null value in a column may indicate that there is an appropriate value for that attribute,and although the value is known no one has entered the value into the database.

Accepted Answer

A) True 
 B)False

Question 3

A missing value is called a null value.

Accepted Answer

A) True 
 B)False

Question 4

You have been given two tables,CUSTOMER and SALE.You want to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber
You run the following SQL query:
SELECT CustomerNumber
FROM SALE
WHERE CustomerNumber NOT IN
(SELECT CustomerNumber
FROM SALE,CUSTOMER
WHERE SALE.CustomerNumber = CUSTOMER.CustomerNumber);
What is shown in the results of this query?

Accepted Answer

A) All values of CustomerNumber that match the constraint. 
B) All values of CustomerNumber that violate the constraint. 
C) All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber. 
D) A and C 
E) B and C 
A) All values of CustomerNumber that match the constraint. 
B) All values of CustomerNumber that violate the constraint. 
C) All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber. 
D) A and C 
E) B and C

Question 5

When a table is created using existing data from multiple sources,you are likely to find that some data values have never been provided.This is an example of ________.

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 6

When accessing table structure,how do you determine how many rows are in a table?

Accepted Answer

To determine how many rows are

Question 7

If you have a table with a set of columns named "Child01","Child02" and "Child03",the table has the multivalued,multicolumn problem.

Accepted Answer

A) True 
 B)False

Question 8

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 9

The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.

Accepted Answer

A) True 
 B)False

Question 10

When you are given a set of tables and asked to create a database to store their data,the first step is to assess the tables' structure and content.

Accepted Answer

A) True 
 B)False

Question 11

The advantages of normalization include ________.

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 12

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 13

Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that a column named Remarks has been included,and is populated with inconsistent and verbose verbal data.This is an example of ________.

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 14

When you are creating a database from existing data,you will have only minor problems with inconsistent values.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that some data values that were provided were never entered into the table.This is an example of ________.

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 17

Read-only databases are often updated.

Accepted Answer

A) True 
 B)False

Question 18

SQL statements can be used to create referential integrity statements for normalized tables and are created during the normalization process.

Accepted Answer

A) True 
 B)False

Question 19

A classic example of unneeded normalization is when we are dealing with ________.

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 20

When a table is created using existing data from multiple sources,you are likely to find that some data values that have never been provided are simply and obviously wrong and inappropriate.This is an example of ________.

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.

Exam 4: Database Design Using Normalization

Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.

A null value in a column may indicate that there is an appropriate value for that attribute,and although the value is known no one has entered the value into the database.

A missing value is called a null value.

When a table is created using existing data from multiple sources,you are likely to find that some data values have never been provided.This is an example of ________.

When accessing table structure,how do you determine how many rows are in a table?

If you have a table with a set of columns named "Child01","Child02" and "Child03",the table has the multivalued,multicolumn problem.

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

The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.

When you are given a set of tables and asked to create a database to store their data,the first step is to assess the tables' structure and content.

The advantages of normalization include ________.

The second step in assessing table structure includes ________.

Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that a column named Remarks has been included,and is populated with inconsistent and verbose verbal data.This is an example of ________.

When you are creating a database from existing data,you will have only minor problems with inconsistent values.

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

Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that some data values that were provided were never entered into the table.This is an example of ________.

Read-only databases are often updated.

SQL statements can be used to create referential integrity statements for normalized tables and are created during the normalization process.

A classic example of unneeded normalization is when we are dealing with ________.

When a table is created using existing data from multiple sources,you are likely to find that some data values that have never been provided are simply and obviously wrong and inappropriate.This is an example of ________.

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