Question 1

A means must be created to recover all test databases to their original state during the redesign testing process.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 tableE) B) and C)
F) C) and D)

Question 4

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 modelingE) A) and B)
F) A) and C)

Question 5

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)  Both A and B are correctE) A) and C)
F) B) and D)

Question 6

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

Accepted Answer

A)  SELECT C1.CustName,C1.SalesRepNoFROM CUSTOMER C1WHERE C1.SalesRepNo IN(SELECT S1.SalesRepNoFROM SALESREP S1WHERE S1.RepName = 'Smith') ;
B)  SELECT C1.CustName,C1.SalesRepNoFROM CUSTOMER C1WHERE C1.SalesRepNo IN(SELECT S1.SaleRepNoFROM SALESREP S1WHERE S1.RepName = 'Smith') AND C1.SalesRepNo=S1.SalesRepNo) ;
C)  SELECT C1.CustName,C1.SalesRepNoFROM CUSTOMER C1WHERE C1.SalesRepNo IN(SELECT S1.SaleRepNoFROM SALESREP S1WHERE S1.RepName = 'Smith') AND C1.SalesRepNoS1.SalesRepNo) ;
D)  SELECT C1.CustName,C1.SalesRepNoFROM CUSTOMER C1WHERE C1.SalesRepNo IN(SELECT C2.SaleRepNoFROM CUSTOMER C2WHERE C1.SalesRepNo=C2.SalesRepNo) ;AND C1.OrderNoC2.OrderNo) ;E) All of the above
F) A) and B)

Question 7

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 8

When decreasing maximum cardinalities,there will always be data loss.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Correlated subqueries can be used to verify functional dependencies.

Accepted Answer

A) True 
 B)False  True

Question 11

In the SQL statement:
SELECT S1.CustName,S1.SalesRepNo FROM SALES S1;
the "S1" is called an alias.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

The data model produced by reverse engineering is a(n) ________.

Accepted Answer

A)  conceptual schema
B)  internal schema
C)  dependency graph
D)  table-relationship diagramE) A) and D)
F) B) and C)

Question 15

To change the minimum cardinality on the parent side from zero to one,the foreign key,which would have been NULL,must be changed to NOT NULL.

Accepted Answer

A) True 
 B)False

Question 16

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 conditionE) None of the above
F) B) and D)

Question 17

In a correlated subquery of a database that has tables TableOne and TableTwo,if table TableOne is used in the upper SELECT statement,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 TableTwoE) A) and B)
F) None of the above

Question 18

What is a correlated subquery? Include an example.

Accepted Answer

A correlated subquery uses the standard SQL subquery structure of a SELECT statement (called the lower SELECT)within the WHERE clause of a controlling (or upper)SELECT.However,where a non-correlated subquery uses different tables in the upper and lower SELECTS,the correlated subquery uses the same table in both SELECTS.SQL aliases are used to provide different table names within the query.When a non-correlated subquery is processed,the lower SELECT is processed first and the entire result set of the lower SELECT is passed to the upper SELECT.When a correlated subquery is processed,a nested processing is used where each individual result of the lower SELECT is returned one at a time to the upper SELECT for processing.Here is an example that finds the last names of all students advised by a faculty whose last name is 'Smith':
SELECT S.LastName
FROM Student S
WHERE EXISTS
(SELECT *
FROM FACULTY F
WHERE F.FacultyID = S.AdvisorID AND F.LastName = 'Smith'));

Question 19

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 conditionE) B) and D)
F) B) and C)

Question 20

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

Exam 8: Database Redesign

A means must be created to recover all test databases to their original state during the redesign testing process.

Correct Answer
verified
True

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

Correct Answer
verified

To change a table name,we ________.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

When decreasing maximum cardinalities,there will always be data loss.

Correct Answer
verified

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

Correct Answer
verified

Correlated subqueries can be used to verify functional dependencies.

Correct Answer
verified
True

In the SQL statement: SELECT S1.CustName,S1.SalesRepNo FROM SALES S1; the "S1" is called an alias.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

The data model produced by reverse engineering is a(n) ________.

Correct Answer
verified

To change the minimum cardinality on the parent side from zero to one,the foreign key,which would have been NULL,must be changed to NOT NULL.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

What is a correlated subquery? Include an example.

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

Correct Answer
verified

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

Correct Answer
verified

Exam 8: Database Redesign

A means must be created to recover all test databases to their original state during the redesign testing process.

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

To change a table name,we ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

When decreasing maximum cardinalities,there will always be data loss.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correlated subqueries can be used to verify functional dependencies.

Correct AnswerverifiedTrue

In the SQL statement: SELECT S1.CustName,S1.SalesRepNo FROM SALES S1; the "S1" is called an alias.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

The data model produced by reverse engineering is a(n) ________.

Correct AnswerverifiedShow Answer

To change the minimum cardinality on the parent side from zero to one,the foreign key,which would have been NULL,must be changed to NOT NULL.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a correlated subquery? Include an example.

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified