Question 1

The defining characteristic of BCNF is that a table is in BCNF if ________.

Accepted Answer

A) all rows are unique 
B) all columns are consistent 
C) the primary key is a candidate key 
D) all determinants are candidate keys 
E) all candidate keys are determinants 
A) all rows are unique 
B) all columns are consistent 
C) the primary key is a candidate key 
D) all determinants are candidate keys 
E) all candidate keys are determinants

Question 2

Null values are a problem because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 3

A missing value is called a null value.

Accepted Answer

A) True 
 B)False

Question 4

Read-only databases often use several copies of a set of the same data,where each copy is modified for a specific use.

Accepted Answer

A) True 
 B)False

Question 5

When examining data values as a part of assessing table structure,there is no need to try to determine candidate keys other than the table's primary key.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

Denormalization is simple-join the data together and store it in a table.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Normalization is an advantage for a read-only database.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

Inconsistent values are different forms

Question 14

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 15

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 16

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) A,B,and C 
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) A,B,and C 
E) None of the above is correct.

Question 17

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 18

Creating a read-only database is a job often given to beginning database professionals.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

General-purpose remarks columns are colu

Question 20

Relations in BCNF have no modification anomalies in regard to functional dependencies.

Accepted Answer

A) True 
 B)False

Exam 4: Database Design Using Normalization

The defining characteristic of BCNF is that a table is in BCNF if ________.

Null values are a problem because they are ambiguous.

A missing value is called a null value.

Read-only databases often use several copies of a set of the same data,where each copy is modified for a specific use.

When examining data values as a part of assessing table structure,there is no need to try to determine candidate keys other than the table's primary key.

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

Denormalization is simple-join the data together and store it in a table.

The SQL keyword IS NULL can be used to ________.

Normalization is an advantage for a read-only database.

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

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

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

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.

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

A null value can indicate which of the following conditions?

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

Creating a read-only database is a job often given to beginning database professionals.

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

Relations in BCNF have no modification anomalies in regard to functional dependencies.

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