Question 1

The second step in assessing table structure is to examine data values and determine dependencies and keys.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.

Accepted Answer

A) True 
 B)False

Question 5

Most DBMS products will let you define a primary key on a column that contains null values.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Null values are a problem because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 14

The first step in assessing table structure is to count rows and examine columns.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

Inconsistent values are different forms

Question 18

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

Question 19

Database design varies depending on whether you're building an updateable database or a read-only database.

Accepted Answer

A) True 
 B)False

Question 20

When examining data values as a part of assessing table structure,you should try to determine multivalued dependencies.

Accepted Answer

A) True 
 B)False

Exam 4: Database Design Using Normalization

The second step in assessing table structure is to examine data values and determine dependencies and keys.

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.

Read-only databases are used for ________.

Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.

Most DBMS products will let you define a primary key on a column that contains null values.

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

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

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.

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

The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.

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

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

Null values are a problem because they are ambiguous.

The first step in assessing table structure is to count rows and examine columns.

The disadvantages of normalization include ________.

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

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

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

Database design varies depending on whether you're building an updateable database or a read-only database.

When examining data values as a part of assessing table structure,you should try to determine multivalued 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

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