Question 1

Design guidelines and priorities are the same whether you're working with an updatable database or a read-only database.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

The disadvantages 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 5

Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

General-purpose remarks columns rarely contain important data.

Accepted Answer

A) True 
 B)False

Question 8

A form of multivalued dependency is found in ________.

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 9

Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.

Accepted Answer

First,you should count the number of row

Question 10

You are creating a BOAT table using existing data from multiple sources,and you find that you have "power boat blue","boat,power,blue" and "blue power boat" as data values for the same column.This is an example of the inconsistent values problem.

Accepted Answer

A) True 
 B)False

Question 11

The SQL IS NULL keyword can be used to count the number of nulls in a column.

Accepted Answer

A) True 
 B)False

Question 12

Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.

Accepted Answer

A) True 
 B)False

Question 13

One situation created by the multivalued,multicolumn problem is that the maximum number of data values for an attribute is limited.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

To determine how many rows are

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

Read-only databases are used for ________.

Accepted Answer

A) updating 
B) querying 
C) reporting 
D) A and B 
E) B and C 
A) updating 
B) querying 
C) reporting 
D) A and B 
E) B and C

Question 19

If you see a column name Notes,it is likely that this is a general-purpose remarks column.

Accepted Answer

A) True 
 B)False

Question 20

To limit the number of rows retrieved from 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 *

Exam 4: Database Design Using Normalization

Design guidelines and priorities are the same whether you're working with an updatable database or a read-only database.

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 the process of joining previously normalized tables back together.

The disadvantages of normalization include ________.

Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.

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

General-purpose remarks columns rarely contain important data.

A form of multivalued dependency is found in ________.

Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.

You are creating a BOAT table using existing data from multiple sources,and you find that you have "power boat blue","boat,power,blue" and "blue power boat" as data values for the same column.This is an example of the inconsistent values problem.

The SQL IS NULL keyword can be used to count the number of nulls in a column.

Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.

One situation created by the multivalued,multicolumn problem is that the maximum number of data values for an attribute is limited.

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

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

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

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.

Read-only databases are used for ________.

If you see a column name Notes,it is likely that this is a general-purpose remarks column.

To limit the number of rows retrieved from a table,use the SQL construct ________.

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