Question 1

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 2

The NOT EXISTS keyword will be true if any row in the subquery fails to meet the condition.

Accepted Answer

A) True 
 B)False

Question 3

The design produced by reverse engineering may be described as a table-relationship diagram.

Accepted Answer

A) True 
 B)False

Question 4

To drop a primary key column from a table the primary key constraint must first be dropped,but this does not require that related foreign keys based on the column be dropped.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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 9

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 10

In a correlated subquery,the DBMS can run the lower SELECT statement by itself and then send the results to the upper SELECT statement.

Accepted Answer

A) True 
 B)False

Question 11

In order to minimize the need to change table names,some organizations have a policy that no user or application should ever employ the true name of a table,but use views as table aliases instead.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

In the database redesign process,SQL tools that are useful for testing whether or not certain conditions or assumptions are valid are ________.

Accepted Answer

A) correlated subqueries 
B) EXISTS 
C) NOT EXISTS 
D) B and C 
E) A,B,and C 
A) correlated subqueries 
B) EXISTS 
C) NOT EXISTS 
D) B and C 
E) A,B,and C

Question 15

The authors refer to the data model produced by reverse engineering as the RE data model.

Accepted Answer

A) True 
 B)False

Question 16

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 17

In a double nested set of NOT EXISTS SELECT statements,________.

Accepted Answer

A) if a row does not match any row,then it matches every row 
B) if a row matches any row,then it matches every row 
C) if a row does not match any row,then it does not match every row 
D) if a row matches any row,then it does not match every row 
E) if a row does not match any row,then referential integrity has been broken 
A) if a row does not match any row,then it matches every row 
B) if a row matches any row,then it matches every row 
C) if a row does not match any row,then it does not match every row 
D) if a row matches any row,then it does not match every row 
E) if a row does not match any row,then referential integrity has been broken

Question 18

A double nested set of NOT EXISTS SELECT statements is ________.

Accepted Answer

A) a famous pattern in SQL 
B) regularly used 
C) rarely used to nonexistent in the real world 
D) A and B 
E) A and C 
A) a famous pattern in SQL 
B) regularly used 
C) rarely used to nonexistent in the real world 
D) A and B 
E) A and C

Question 19

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

Accepted Answer

Typically,there are at least three diffe

Question 20

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

Exam 8: Database Redesign

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

The NOT EXISTS keyword will be true if any row in the subquery fails to meet the condition.

The design produced by reverse engineering may be described as a table-relationship diagram.

To drop a primary key column from a table the primary key constraint must first be dropped,but this does not require that related foreign keys based on the column be dropped.

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

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.

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

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

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.

In a correlated subquery,the DBMS can run the lower SELECT statement by itself and then send the results to the upper SELECT statement.

In order to minimize the need to change table names,some organizations have a policy that no user or application should ever employ the true name of a table,but use views as table aliases instead.

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

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

In the database redesign process,SQL tools that are useful for testing whether or not certain conditions or assumptions are valid are ________.

The authors refer to the data model produced by reverse engineering as the RE data model.

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

In a double nested set of NOT EXISTS SELECT statements,________.

A double nested set of NOT EXISTS SELECT statements is ________.

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

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

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

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