Question 1

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 structural changes.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) Drop all constraints from the table 
B) Drop the foreign keys from the table 
C) Drop the foreign keys in other tables based on the primary key column 
D) Drop the primary key(s)of any table(s)to which this one is related 
A) Drop all constraints from the table 
B) Drop the foreign keys from the table 
C) Drop the foreign keys in other tables based on the primary key column 
D) Drop the primary key(s)of any table(s)to which this one is related

Question 3

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 4

When increasing cardinalities from 1:N to N:M,which of the following steps is not 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) Drop the primary key 
A) Create an intersection table 
B) Populate the intersection table 
C) Drop the old foreign key 
D) Drop the primary key

Question 5

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 
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

Question 6

Which of the following different copies of the database schema is typically not used in the database redesign process?

Accepted Answer

A) Small test database 
B) Data warehouse database 
C) Operational database 
D) Large test database 
A) Small test database 
B) Data warehouse database 
C) Operational database 
D) Large test database

Question 7

The data model produced by reverse engineering is not truly a logical model because it will contain ________.

Accepted Answer

A) tables for strong entities 
B) supertype/subtype tables 
C) tables for ID-dependent entities 
D) intersection tables 
A) tables for strong entities 
B) supertype/subtype tables 
C) tables for ID-dependent entities 
D) intersection tables

Question 8

Database redesign is equally difficult whether or not the database has data in it.

Accepted Answer

A) True 
 B)False

Question 9

The use of a doubly nested set of NOT EXISTS SELECT statements is so rare that even if you are a professional database developer you will probably never see it used.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

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

Question 12

When dropping a foreign 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 foreign key constraint from the table 
B) Drop the foreign key column from the table 
C) Drop the primary key in the other table referenced by the referential integrity constraint 
D) Both A and B are correct 
A) Drop the foreign key constraint from the table 
B) Drop the foreign key column from the table 
C) Drop the primary key in the other table referenced by the referential integrity constraint 
D) Both A and B are correct

Question 13

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 
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

Question 14

A doubly 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) Both A and B are correct 
A) a famous pattern in SQL 
B) regularly used 
C) rarely used to nonexistent in the real world 
D) Both A and B are correct

Question 15

During the database redesign process,you discover that when you try to change a DEPARTMENT name (the department's primary key),the change is disallowed by the DBMS due to your design of the EMPLOYEE table (which has a foreign key referencing DEPARTMENT)You want the change to be allowed.In order to fix this,you use what SQL syntax?

Accepted Answer

A) ON UPDATE CASCADE 
B) ON DELETE CASCADE 
C) ADD CONSTRAINT 
D) FOREIGN KEY 
A) ON UPDATE CASCADE 
B) ON DELETE CASCADE 
C) ADD CONSTRAINT 
D) FOREIGN KEY

Question 16

When dropping tables and relationships,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 foreign key constraints from the tables 
B) Drop the tables 
C) Drop the primary key constraints from the tables 
D) Both A and B are correct 
A) Drop the foreign key constraints from the tables 
B) Drop the tables 
C) Drop the primary key constraints from the tables 
D) Both A and B are correct

Question 17

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 18

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) Revising user account name policies 
D) Maintaining backups of the existing database 
A) Checking whether certain conditions or assumptions about the data are valid 
B) Reverse engineering the data model 
C) Revising user account name policies 
D) Maintaining backups of the existing database

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 8: Database Redesign

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 structural changes.

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

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

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

Database redesign is fairly easy when ________.

Which of the following different copies of the database schema is typically not used in the database redesign process?

The data model produced by reverse engineering is not truly a logical model because it will contain ________.

Database redesign is equally difficult whether or not the database has data in it.

The use of a doubly nested set of NOT EXISTS SELECT statements is so rare that even if you are a professional database developer you will probably never see it used.

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.

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

When dropping a foreign 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. )

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

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

When dropping tables and relationships,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. )

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

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

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.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters