Question 1

A correlated subquery looks very different from a noncorrelated subquery.

Accepted Answer

A) True 
 B)False

Question 2

A doubly 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 3

A doubly nested set of 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 4

What is the process for adding a NOT NULL column to a table?

Accepted Answer

There are three steps in adding a NOT NU

Question 5

During the database redesign process,you discover that when an ORDER is deleted,its corresponding entries in the LINE_ITEM table are not deleted (but you would like them to be).In order to fix,this,you use what SQL syntax?

Accepted Answer

A) ON UPDATE CASCADE 
B) ON DELETE CASCADE 
C) CASCADE CONSTRAINTS 
D) DEFAULT 
A) ON UPDATE CASCADE 
B) ON DELETE CASCADE 
C) CASCADE CONSTRAINTS 
D) DEFAULT

Question 6

To drop a nonkey 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

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

Accepted Answer

A) data 
B) foreign keys 
C) ad-hoc SQL queries 
D) triggers 
A) data 
B) foreign keys 
C) ad-hoc SQL queries 
D) triggers

Question 8

SQL queries that use EXISTS and NOT EXISTS are ________.

Accepted Answer

A) normal subqueries 
B) correlated subqueries 
C) uncorrelated subqueries 
D) constraint dependent subqueries 
A) normal subqueries 
B) correlated subqueries 
C) uncorrelated subqueries 
D) constraint dependent subqueries

Question 9

When changing the minimum cardinality on the parent side of the relationship from zero to one,the foreign key ________.

Accepted Answer

A) must be changed from NULL to NOT NULL 
B) must be changed from NOT NULL to NULL 
C) must be changed to a composite key 
D) must be changed to a surrogate key 
A) must be changed from NULL to NOT NULL 
B) must be changed from NOT NULL to NULL 
C) must be changed to a composite key 
D) must be changed to a surrogate key

Question 10

Typically,there are at least four different copies of the database schema used in the redesign process.

Accepted Answer

A) True 
 B)False

Question 11

In a correlated subquery,the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) UPDATE 
B) DROP TABLE 
C) CREATE TRIGGER 
D) NOT EXISTS 
A) UPDATE 
B) DROP TABLE 
C) CREATE TRIGGER 
D) NOT EXISTS

Question 13

There is a common trap in writing a correlated subquery,which will cause no rows to ever be displayed in the results.

Accepted Answer

A) True 
 B)False

Question 14

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 
A) never occurs in database redesign 
B) rarely occurs in database redesign 
C) commonly occurs in database redesign 
D) always occurs in database redesign

Question 15

Dependency graphs are graphical displays like bar charts.

Accepted Answer

A) True 
 B)False

Question 16

When running a correlated subquery,the DBMS ________.

Accepted Answer

A) runs the lower SELECT statement by itself and then sends the results to the upper SELECT statement. 
B) runs the upper SELECT statement by itself and then sends the results to the lower SELECT statement. 
C) alternates running the lower SELECT statement with running the upper SELECT statement based on each result of the lower SELECT statement 
D) Either A or B may be used depending on the query. 
A) runs the lower SELECT statement by itself and then sends the results to the upper SELECT statement. 
B) runs the upper SELECT statement by itself and then sends the results to the lower SELECT statement. 
C) alternates running the lower SELECT statement with running the upper SELECT statement based on each result of the lower SELECT statement 
D) Either A or B may be used depending on the query.

Question 17

The data model produced by reverse engineering is a true conceptual schema.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

EXISTS and NOT EXISTS are actually just another form of correlated subqueries.

Accepted Answer

A) True 
 B)False

Question 20

What is a dependency graph,and what is it used for in database redesign?

Accepted Answer

Dependency graphs are not a graphical di

Exam 8: Database Redesign

A correlated subquery looks very different from a noncorrelated subquery.

A doubly nested set of NOT EXISTS SELECT statements can be used to find rows that meet some specified condition for every row in a table.

A doubly nested set of EXISTS SELECT statements can be used to find rows that meet some specified condition for every row in a table.

What is the process for adding a NOT NULL column to a table?

During the database redesign process,you discover that when an ORDER is deleted,its corresponding entries in the LINE_ITEM table are not deleted (but you would like them to be).In order to fix,this,you use what SQL syntax?

To drop a nonkey column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.

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

SQL queries that use EXISTS and NOT EXISTS are ________.

When changing the minimum cardinality on the parent side of the relationship from zero to one,the foreign key ________.

Typically,there are at least four different copies of the database schema used in the redesign process.

In a correlated subquery,the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement.

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

There is a common trap in writing a correlated subquery,which will cause no rows to ever be displayed in the results.

Changing cardinalities ________.

Dependency graphs are graphical displays like bar charts.

When running a correlated subquery,the DBMS ________.

The data model produced by reverse engineering is a true conceptual schema.

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

EXISTS and NOT EXISTS are actually just another form of correlated subqueries.

What is a dependency graph,and what is it used for in database redesign?

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