Question 1

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 2

Explain and contrast the results provided by the EXISTS,NOT EXISTS,and doubly-nested NOT EXISTS keywords.

Accepted Answer

The EXISTS and NOT EXISTS keywords are u

Question 3

Why do databases need redesigning?

Accepted Answer

Databases need redesigning for two reaso

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

When redesigning a database,how can we check assumptions about functional dependencies?

Accepted Answer

There are two related SQL techniques tha

Question 6

In the SQL statements SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER C1;
The "C1" is called a(n)________.

Accepted Answer

A) term 
B) alias 
C) convention 
D) label 
A) term 
B) alias 
C) convention 
D) label

Question 7

Depending on the DBMS,when changing the minimum cardinality on the parent side from zero to one,the foreign key constraint that defines the relationship may have to be dropped before the change is made and re-added afterwards.

Accepted Answer

A) True 
 B)False

Question 8

SQL contains an SQL command RENAME TABLENAME that can be used to change table names.

Accepted Answer

A) True 
 B)False

Question 9

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 
A) conceptual schema 
B) internal schema 
C) dependency graph 
D) table-relationship diagram

Question 10

In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.

Accepted Answer

A) reverse engineer all test databases 
B) graph dependencies in all test databases 
C) recover all test databases to their original state 
D) re-interview all relevant users 
A) reverse engineer all test databases 
B) graph dependencies in all test databases 
C) recover all test databases to their original state 
D) re-interview all relevant users

Question 11

To drop a constraint,no preliminary steps are needed and we can simply use the ALTER TABLE DROP CONSTRAINT statement.

Accepted Answer

A) True 
 B)False

Question 12

Although correlated subqueries are useful in database redesign,they cannot be used to verify functional dependencies.

Accepted Answer

A) True 
 B)False

Question 13

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 14

The use of a doubly nested set of NOT EXISTS SELECT statements is a famous pattern in SQL use.

Accepted Answer

A) True 
 B)False

Question 15

When using queries with EXISTS and NOT EXISTS,the processing of the associated SELECT statements must be nested.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Because EXISTS and NOT EXISTS are forms of correlated subqueries,the processing of the associated SELECT statements must be nested.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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) Both A and B are correct 
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) Both A and B are correct

Question 20

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

Accepted Answer

A) if a row does not 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 
A) if a row does not 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

Exam 8: Database Redesign

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

Explain and contrast the results provided by the EXISTS,NOT EXISTS,and doubly-nested NOT EXISTS keywords.

Why do databases need redesigning?

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

When redesigning a database,how can we check assumptions about functional dependencies?

In the SQL statements SELECT C1.CustName,C1.SalesRepNo FROM CUSTOMER C1; The "C1" is called a(n)________.

Depending on the DBMS,when changing the minimum cardinality on the parent side from zero to one,the foreign key constraint that defines the relationship may have to be dropped before the change is made and re-added afterwards.

SQL contains an SQL command RENAME TABLENAME that can be used to change table names.

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

In order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.

To drop a constraint,no preliminary steps are needed and we can simply use the ALTER TABLE DROP CONSTRAINT statement.

Although correlated subqueries are useful in database redesign,they cannot be used to verify functional dependencies.

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.

The use of a doubly nested set of NOT EXISTS SELECT statements is a famous pattern in SQL use.

When using queries with EXISTS and NOT EXISTS,the processing of the associated SELECT statements must be nested.

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.

Because EXISTS and NOT EXISTS are forms of correlated subqueries,the processing of the associated SELECT statements must be nested.

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.

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

In a doubly nested set of NOT EXISTS 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