Question 1

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 2

In the database redesign process,before proceeding with the redesign it is often useful to ________.

Accepted Answer

A) check whether certain conditions or assumptions about the data are valid 
B) find out why the design was not done properly the first time 
C) stop information systems and users from influencing each other 
D) set standards for user behavior 
E) All of the above 
A) check whether certain conditions or assumptions about the data are valid 
B) find out why the design was not done properly the first time 
C) stop information systems and users from influencing each other 
D) set standards for user behavior 
E) All of the above

Question 3

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 4

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 5

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 6

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 7

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 8

If a DEFAULT constraint is included when a new column is added to a table,the default value is only applied to new rows and not to the existing rows at the time the new column is added.

Accepted Answer

A) True 
 B)False

Question 9

When dropping a nonkey column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

Accepted Answer

A) Drop any column constraints from the table 
B) Drop the column from the table 
C) Drop any foreign keys constraints based on the column 
D) A and B 
E) A,B,and C 
A) Drop any column constraints from the table 
B) Drop the column from the table 
C) Drop any foreign keys constraints based on the column 
D) A and B 
E) A,B,and C

Question 10

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 11

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 12

Which of the following SQL statements is a correctly stated correlated subquery?

Accepted Answer

A) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith'); 
B) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNo=S1.SalesRepNo); 
C) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNoS1.SalesRepNo); 
D) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT C2.SaleRepNo
FROM CUSTOMER C2
WHERE C1.SalesRepNo=C2.SalesRepNo);
AND C1.OrderNoC2.OrderNo); 
E) None of the above is a correctly stated correlated subquery. 
A) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith'); 
B) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNo=S1.SalesRepNo); 
C) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = 'Smith')
AND C1.SalesRepNoS1.SalesRepNo); 
D) SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT C2.SaleRepNo
FROM CUSTOMER C2
WHERE C1.SalesRepNo=C2.SalesRepNo);
AND C1.OrderNoC2.OrderNo); 
E) None of the above is a correctly stated correlated subquery.

Question 13

Which of the following are difficulties when changing the maximum cardinality from 1:1 to 1:N?

Accepted Answer

A) Preserving the existing tables 
B) Preserving the existing relationships 
C) Preserving the existing data 
D) A and B 
E) A,B,and C 
A) Preserving the existing tables 
B) Preserving the existing relationships 
C) Preserving the existing data 
D) A and B 
E) A,B,and C

Question 14

To change a table name,we ________.

Accepted Answer

A) use the SQL RENAME TABLE command 
B) use the SQL ALTER TABLENAME command 
C) use the SQL MODIFY TABLENAME command 
D) create a new table,move the data,and drop the old table 
E) None of the above is the correct way to change a table name. 
A) use the SQL RENAME TABLE command 
B) use the SQL ALTER TABLENAME command 
C) use the SQL MODIFY TABLENAME command 
D) create a new table,move the data,and drop the old table 
E) None of the above is the correct way to change a table name.

Question 15

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 16

If a DEFAULT constraint is included when a new column is added to a table,the default value is applied to ________.

Accepted Answer

A) all existing rows at the time the column is added 
B) all new rows 
C) all new rows but only after the UPDATE command is issued 
D) A and B 
E) A and C 
A) all existing rows at the time the column is added 
B) all new rows 
C) all new rows but only after the UPDATE command is issued 
D) A and B 
E) A and C

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 20

When dropping a primary key column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

Accepted Answer

A) Drop the primary key constraint from the table 
B) Drop the primary key column from the table 
C) Drop the foreign keys in other tables based on the primary key column 
D) A and B 
E) A,B,and C 
A) Drop the primary key constraint from the table 
B) Drop the primary key column from the table 
C) Drop the foreign keys in other tables based on the primary key column 
D) A and B 
E) A,B,and C

Exam 8: Database Redesign

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

In the database redesign process,before proceeding with the redesign it is often useful to ________.

Changing cardinalities ________.

A dependency graph should include:

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

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.

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.

If a DEFAULT constraint is included when a new column is added to a table,the default value is only applied to new rows and not to the existing rows at the time the new column is added.

When dropping a nonkey column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

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

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.

Which of the following SQL statements is a correctly stated correlated subquery?

Which of the following are difficulties when changing the maximum cardinality from 1:1 to 1:N?

To change a table name,we ________.

When decreasing cardinalities,there will always be ________.

If a DEFAULT constraint is included when a new column is added to a table,the default value is applied to ________.

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

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

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

When dropping a primary key column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

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