Question 1

A correlated subquery,looks very different from a noncorrelated subquery.

Accepted Answer

A) True 
 B)False

Question 2

Discuss the role of backup and test databases in database redesign.

Accepted Answer

Typically,there are at least three diffe

Question 3

To add a NOT NULL column to a table,we first add a NULL column,then we insert values into every row,and finally we change the NULL constraint to NOT NULL.

Accepted Answer

A) True 
 B)False

Question 4

When changing column data types,which of the following data conversions will either usually or always succeed?

Accepted Answer

A) Numeric → char or varchar 
B) Date or money → char or varchar 
C) Char or varchar → numeric,date or money 
D) A and B 
E) A,B and C 
A) Numeric → char or varchar 
B) Date or money → char or varchar 
C) Char or varchar → numeric,date or money 
D) A and B 
E) A,B and C

Question 5

When increasing cardinalities from 1:N to N:M,we basically create a new intersection table,fill it with data and drop the old foreign key.

Accepted Answer

A) True 
 B)False

Question 6

When decreasing cardinalities,there will always be ________.

Accepted Answer

A) relationship loss 
B) foreign key loss 
C) data loss 
D) A and B 
E) A,B and C 
A) relationship loss 
B) foreign key loss 
C) data loss 
D) A and B 
E) A,B and C

Question 7

The EXISTS keyword will be true if any row in the subquery meets the condition.

Accepted Answer

A) True 
 B)False

Question 8

In a correlated subquery,the same table is used in the upper and lower SELECT statements.

Accepted Answer

A) True 
 B)False

Question 9

When running an SQL query that uses EXISTS,the EXISTS keyword will be true if ________.

Accepted Answer

A) any row in the subquery meets the condition 
B) all rows in the subquery meet the condition 
C) no row in the subquery meets the condition 
D) any row in the subquery fails to meet the condition 
E) all rows in the subquery fail to meet the condition 
A) any row in the subquery meets the condition 
B) all rows in the subquery meet the condition 
C) no row in the subquery meets the condition 
D) any row in the subquery fails to meet the condition 
E) all rows in the subquery fail to meet the condition

Question 10

Changing cardinalities ________.

Accepted Answer

A) never occurs in database redesign 
B) rarely occurs in database redesign 
C) commonly occurs in database redesign 
D) always occurs in database redesign 
E) cannot be done once a database is implemented 
A) never occurs in database redesign 
B) rarely occurs in database redesign 
C) commonly occurs in database redesign 
D) always occurs in database redesign 
E) cannot be done once a database is implemented

Question 11

In a correlated subquery,the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement.

Accepted Answer

A) True 
 B)False

Question 12

There is a common trap in writing a correlated subquery,which will cause no rows to ever be displayed in the results.

Accepted Answer

A) True 
 B)False

Question 13

To add a NULL column to a table,we simply use the MODIFY TABLE statement.

Accepted Answer

A) True 
 B)False

Question 14

When running an SQL query that uses NOT EXISTS,the NOT EXISTS keyword will be true if ________.

Accepted Answer

A) any row in the subquery meets the condition 
B) all rows in the subquery meet the condition 
C) no row in the subquery meets the condition 
D) any row in the subquery fails to meet the condition 
E) all rows in the subquery fail to meet the condition 
A) any row in the subquery meets the condition 
B) all rows in the subquery meet the condition 
C) no row in the subquery meets the condition 
D) any row in the subquery fails to meet the condition 
E) all rows in the subquery fail to meet the condition

Question 15

To drop a foreign key 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 16

Dependency graphs are graphical displays like bar charts.

Accepted Answer

A) True 
 B)False

Question 17

Deleting tables and relationships is basically a matter of dropping foreign key constraints and then dropping the tables.

Accepted Answer

A) True 
 B)False

Question 18

To add a 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 table with the NULL column,move the other data,and drop the old table 
E) None of the above is the correct way to add a NULL column. 
A) use the REVISE TABLE command 
B) use the ALTER TABLE command 
C) use the MODIFY TABLE command 
D) create a new table with the NULL column,move the other data,and drop the old table 
E) None of the above is the correct way to add a NULL column.

Question 19

In a correlated subquery of a database that has tables TableOne and TableTwo,and if table TableOne is used in the upper SELECT statements,then which table is used in the lower SELECT statement?

Accepted Answer

A) TableOne 
B) TableTwo 
C) both TableOne and TableTwo 
D) either TableOne or TableTwo 
E) neither TableOne nor TableTwo 
A) TableOne 
B) TableTwo 
C) both TableOne and TableTwo 
D) either TableOne or TableTwo 
E) neither TableOne nor TableTwo

Question 20

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

Exam 8: Database Redesign

A correlated subquery,looks very different from a noncorrelated subquery.

Discuss the role of backup and test databases in database redesign.

To add a NOT NULL column to a table,we first add a NULL column,then we insert values into every row,and finally we change the NULL constraint to NOT NULL.

When changing column data types,which of the following data conversions will either usually or always succeed?

When increasing cardinalities from 1:N to N:M,we basically create a new intersection table,fill it with data and drop the old foreign key.

When decreasing cardinalities,there will always be ________.

The EXISTS keyword will be true if any row in the subquery meets the condition.

In a correlated subquery,the same table is used in the upper and lower SELECT statements.

When running an SQL query that uses EXISTS,the EXISTS keyword will be true if ________.

Changing cardinalities ________.

In a correlated subquery,the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement.

There is a common trap in writing a correlated subquery,which will cause no rows to ever be displayed in the results.

To add a NULL column to a table,we simply use the MODIFY TABLE statement.

When running an SQL query that uses NOT EXISTS,the NOT EXISTS keyword will be true if ________.

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

Dependency graphs are graphical displays like bar charts.

Deleting tables and relationships is basically a matter of dropping foreign key constraints and then dropping the tables.

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

In a correlated subquery of a database that has tables TableOne and TableTwo,and if table TableOne is used in the upper SELECT statements,then which table is used in the lower SELECT statement?

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.

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