Question 1

When running a correlated subquery,the DBMS always uses ________.

Accepted Answer

A) regular processing 
B) nested processing 
C) "quick and dirty" processing 
D) SQL-92 processing 
E) a form of processing that is specific to the DBMS product 
A) regular processing 
B) nested processing 
C) "quick and dirty" processing 
D) SQL-92 processing 
E) a form of processing that is specific to the DBMS product

Question 2

Converting date,money or other more specific data types to char or varchar will usually succeed.

Accepted Answer

A) True 
 B)False

Question 3

SQL queries that use EXISTS and NOT EXISTS are ________.

Accepted Answer

A) normal subqueries 
B) correlated subqueries 
C) uncorrelated subqueries 
D) constraint dependent subqueries 
E) constraint independent subqueries 
A) normal subqueries 
B) correlated subqueries 
C) uncorrelated subqueries 
D) constraint dependent subqueries 
E) constraint independent subqueries

Question 4

What is a correlated subquery?

Accepted Answer

A correlated subquery uses the standard

Question 5

Because of the need to know the functional dependencies in a database,it is a good idea to create a dependency graph.

Accepted Answer

A) True 
 B)False

Question 6

There are several difficulties with increasing cardinalities from 1:1 to 1:N,one of which is preserving the existing relationships.

Accepted Answer

A) True 
 B)False

Question 7

In a real sense,information systems and organizations do not just influence each other,but rather they create each other.

Accepted Answer

A) True 
 B)False

Question 8

When making any change to the database structure,we may need to check for effects of the change on ________.

Accepted Answer

A) data 
B) foreign keys 
C) constraints 
D) triggers 
E) All of the above may need to be checked. 
A) data 
B) foreign keys 
C) constraints 
D) triggers 
E) All of the above may need to be checked.

Question 9

Which of the following is not a possible step in the database redesign process?

Accepted Answer

A) Checking whether certain conditions or assumptions about the data are valid 
B) Reverse engineering the data model 
C) Testing proposed changes 
D) Maintaining backups of the existing database 
E) All of the above are possible steps in the database redesign process. 
A) Checking whether certain conditions or assumptions about the data are valid 
B) Reverse engineering the data model 
C) Testing proposed changes 
D) Maintaining backups of the existing database 
E) All of the above are possible steps in the database redesign process.

Question 10

A dependency graph should include:

Accepted Answer

A) tables 
B) views 
C) triggers 
D) A and B 
E) A,B and C 
A) tables 
B) views 
C) triggers 
D) A and B 
E) A,B and C

Question 11

Database redesign is fairly easy when ________.

Accepted Answer

A) information systems and organizations influence each other 
B) the design was done correctly the first time 
C) there is no data in the database 
D) good backups of the database are available 
E) All of the above. 
A) information systems and organizations influence each other 
B) the design was done correctly the first time 
C) there is no data in the database 
D) good backups of the database are available 
E) All of the above.

Question 12

Explain the results provided by the EXISTS,NOT EXISTS and double NOT EXISTS keywords.

Accepted Answer

The EXISTS and NOT EXISTS keywords are u

Question 13

In the database redesign process,it is often useful to test whether certain conditions or assumptions are valid before proceeding with the redesign.

Accepted Answer

A) True 
 B)False

Question 14

The use of a double nested set of NOT EXISTS SELECT statements can be used to find rows that meet some specified condition for every row in a table.

Accepted Answer

A) True 
 B)False

Question 15

There is no good SQL command that can be used to change table names.

Accepted Answer

A) True 
 B)False

Question 16

In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.

Accepted Answer

A) reverse engineer all test databases 
B) graph dependencies in all test databases 
C) recover all test databases to their original state 
D) A and B 
E) A,B and C 
A) reverse engineer all test databases 
B) graph dependencies in all test databases 
C) recover all test databases to their original state 
D) A and B 
E) A,B and C

Question 17

EXISTS and NOT EXISTS are actually just another form of correlated subqueries.

Accepted Answer

A) True 
 B)False

Question 18

Database redesign is rarely needed because databases are usually built correctly the first time.

Accepted Answer

A) True 
 B)False

Question 19

A continuous circular process of changes in user behaviors and change in the information systems they use is a natural outcome of information system use.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) data modeling 
B) data engineering 
C) reverse engineering 
D) schema modeling 
E) schema engineering 
A) data modeling 
B) data engineering 
C) reverse engineering 
D) schema modeling 
E) schema engineering

Exam 8: Database Redesign

When running a correlated subquery,the DBMS always uses ________.

Converting date,money or other more specific data types to char or varchar will usually succeed.

SQL queries that use EXISTS and NOT EXISTS are ________.

What is a correlated subquery?

Because of the need to know the functional dependencies in a database,it is a good idea to create a dependency graph.

There are several difficulties with increasing cardinalities from 1:1 to 1:N,one of which is preserving the existing relationships.

In a real sense,information systems and organizations do not just influence each other,but rather they create each other.

When making any change to the database structure,we may need to check for effects of the change on ________.

Which of the following is not a possible step in the database redesign process?

A dependency graph should include:

Database redesign is fairly easy when ________.

Explain the results provided by the EXISTS,NOT EXISTS and double NOT EXISTS keywords.

In the database redesign process,it is often useful to test whether certain conditions or assumptions are valid before proceeding with the redesign.

The use of a double nested set of NOT EXISTS SELECT statements can be used to find rows that meet some specified condition for every row in a table.

There is no good SQL command that can be used to change table names.

In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.

EXISTS and NOT EXISTS are actually just another form of correlated subqueries.

Database redesign is rarely needed because databases are usually built correctly the first time.

A continuous circular process of changes in user behaviors and change in the information systems they use is a natural outcome of information system use.

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

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