Question 1

What is reverse engineering and how well does it work?

Accepted Answer

Reverse engineering (RE)is the process o

Question 2

Correlated subqueries can be used to verify functional dependencies.

Accepted Answer

A) True 
 B)False

Question 3

The data model produced by reverse engineering is a true conceptual schema.

Accepted Answer

A) True 
 B)False

Question 4

To drop a nonkey column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.

Accepted Answer

A) True 
 B)False

Question 5

In the SQL statements SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1;
The "C1" is called a(n)________.

Accepted Answer

A) term 
B) alias 
C) convention 
D) phrase 
E) label 
A) term 
B) alias 
C) convention 
D) phrase 
E) label

Question 6

When using queries with EXISTS and NOT EXISTS,the processing of the associated SELECT statements must be nested.

Accepted Answer

A) True 
 B)False

Question 7

What is the process and what are the considerations when changing a table name?

Accepted Answer

To change a table name,we re-create the

Question 8

Even if an organization has a very large database,it will be possible to make a complete backup copy of the operational database prior to making structure changes.

Accepted Answer

A) True 
 B)False

Question 9

Because EXISTS and NOT EXISTS are forms of correlated subqueries,the processing of the associated SELECT statements must be nested.

Accepted Answer

A) True 
 B)False

Question 10

The process of reading an actual database schema and producing a data model from that schema is called reverse engineering.

Accepted Answer

A) True 
 B)False

Question 11

When increasing cardinalities from 1:N to N:M,which of the following steps are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

Accepted Answer

A) Create an intersection table 
B) Populate the intersection table 
C) Drop the old foreign key 
D) A and B 
E) A,B and C 
A) Create an intersection table 
B) Populate the intersection table 
C) Drop the old foreign key 
D) A and B 
E) A,B and C

Question 12

Discuss workable data conversion and possible data loss when changing table data types during a database redesign.

Accepted Answer

Converting Numeric (Number),Money,Date a

Question 13

The use of a double nested set of NOT EXISTS SELECT statements is a famous pattern in SQL use.

Accepted Answer

A) True 
 B)False

Question 14

To add a NOT NULL column to a table,we ________.

Accepted Answer

A) use the REVISE TABLE command 
B) use the ALTER TABLE command 
C) use the MODIFY TABLE command 
D) create a new NULL column,insert data values into every row,and change the NULL constraint to NOT NULL 
E) None of the above is the correct way to add a NOT NULL column to a table. 
A) use the REVISE TABLE command 
B) use the ALTER TABLE command 
C) use the MODIFY TABLE command 
D) create a new NULL column,insert data values into every row,and change the NULL constraint to NOT NULL 
E) None of the above is the correct way to add a NOT NULL column to a table.

Question 15

Changing table names is complicated by the fact that constraints and triggers are often associated with the table and will also need to be changed.

Accepted Answer

A) True 
 B)False

Question 16

When changing the minimum cardinality on the parent side of the relationship from zero to one,the foreign key ________.

Accepted Answer

A) must be changed from NULL to NOT NULL 
B) must be changed from NOT NULL to NULL 
C) must be changed to a composite key 
D) must be changed to a surrogate key 
E) does not change 
A) must be changed from NULL to NOT NULL 
B) must be changed from NOT NULL to NULL 
C) must be changed to a composite key 
D) must be changed to a surrogate key 
E) does not change

Question 17

Because of the need to know the functional dependencies in a database,it is a good idea to create a(n)________.

Accepted Answer

A) conceptual schema 
B) internal schema 
C) dependency graph 
D) table-relationship diagram 
E) entity-relationship diagram 
A) conceptual schema 
B) internal schema 
C) dependency graph 
D) table-relationship diagram 
E) entity-relationship diagram

Question 18

The data model produced by reverse engineering is a(n)________.

Accepted Answer

A) conceptual schema 
B) internal schema 
C) dependency graph 
D) table-relationship diagram 
E) entity-relationship diagram 
A) conceptual schema 
B) internal schema 
C) dependency graph 
D) table-relationship diagram 
E) entity-relationship diagram

Question 19

Although correlated subqueries are useful in database redesign,they cannot be used to verify functional dependencies.

Accepted Answer

A) True 
 B)False

Question 20

In the database redesign process,two SQL tools are useful for testing whether or not certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT EXISTS.

Accepted Answer

A) True 
 B)False

Exam 8: Database Redesign

What is reverse engineering and how well does it work?

Correlated subqueries can be used to verify functional dependencies.

The data model produced by reverse engineering is a true conceptual schema.

To drop a nonkey column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.

In the SQL statements SELECT C1.CustName,C1.SalesRepNo FROM CUSTOMER C1; The "C1" is called a(n)________.

When using queries with EXISTS and NOT EXISTS,the processing of the associated SELECT statements must be nested.

What is the process and what are the considerations when changing a table name?

Even if an organization has a very large database,it will be possible to make a complete backup copy of the operational database prior to making structure changes.

Because EXISTS and NOT EXISTS are forms of correlated subqueries,the processing of the associated SELECT statements must be nested.

The process of reading an actual database schema and producing a data model from that schema is called reverse engineering.

When increasing cardinalities from 1:N to N:M,which of the following steps are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

Discuss workable data conversion and possible data loss when changing table data types during a database redesign.

The use of a double nested set of NOT EXISTS SELECT statements is a famous pattern in SQL use.

To add a NOT NULL column to a table,we ________.

Changing table names is complicated by the fact that constraints and triggers are often associated with the table and will also need to be changed.

When changing the minimum cardinality on the parent side of the relationship from zero to one,the foreign key ________.

Because of the need to know the functional dependencies in a database,it is a good idea to create a(n)________.

The data model produced by reverse engineering is a(n)________.

Although correlated subqueries are useful in database redesign,they cannot be used to verify functional dependencies.

In the database redesign process,two SQL tools are useful for testing whether or not certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT EXISTS.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

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