Exam 8: Database Redesign

Explore all topics

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.

(True/False)

4.8/5

(43)

Question 81

When dropping tables and relationships,which of the following steps are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

(Multiple Choice)

4.8/5

(32)

Question 82

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

(Multiple Choice)

4.9/5

(33)

Question 83

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

(True/False)

4.9/5

(36)

Question 84

To drop a primary key column from a table the primary key constraint must first be dropped,but this does not require that related foreign keys based on the column be dropped.

(True/False)

4.9/5

(33)

Question 85

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

(Multiple Choice)

4.9/5

(38)

Question 86

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

(Multiple Choice)

4.8/5

(39)

Question 87

The continuous circular process of changes is known as the Systems Development Life Cycle (SDLC).

(True/False)

4.9/5

(37)

Question 88

The data model produced by reverse engineering may include some entities that should not appear in the data model.

(True/False)

4.7/5

(37)

Question 89

The design produced by reverse engineering may be described as a table-relationship diagram.

(True/False)

4.9/5

(29)

Question 90

The author refers to the data model produced by reverse engineering as the RE data model.

(True/False)

4.7/5

(32)

Question 91

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

(Essay)

4.9/5

(34)

Question 92

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

(True/False)

4.8/5

(31)

Question 93

In order to minimize the need to change table names some organizations have a policy that no user or application should ever employ the true name of a table,but use views as table aliases instead.

(True/False)

4.8/5

(33)

Question 94

SQL Server 2008 R2 contains a system stored procedure named sp_rename that can be used to change table names.

(True/False)

5.0/5

(38)

Question 95

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

(Multiple Choice)

4.7/5

(30)

Question 96

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

(True/False)

4.8/5

(33)

Question 97

When using a double nested set of NOT EXISTS SELECT statements,a row that does not match any row matches every row.

(True/False)

4.8/5

(28)

Question 98

When decreasing cardinalities,there will always be data loss.

(True/False)

4.9/5

(29)

Question 99

Why do databases need redesigning?

(Essay)

4.8/5

(37)

Question 100

Showing 81 - 100 of 101

Exam 8: Database Redesign

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.

When dropping tables and relationships,which of the following steps are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

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

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

To drop a primary key column from a table the primary key constraint must first be dropped,but this does not require that related foreign keys based on the column be dropped.

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

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

The continuous circular process of changes is known as the Systems Development Life Cycle (SDLC).

The data model produced by reverse engineering may include some entities that should not appear in the data model.

The design produced by reverse engineering may be described as a table-relationship diagram.

The author refers to the data model produced by reverse engineering as the RE data model.

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

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

In order to minimize the need to change table names some organizations have a policy that no user or application should ever employ the true name of a table,but use views as table aliases instead.

SQL Server 2008 R2 contains a system stored procedure named sp_rename that can be used to change table names.

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

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

When using a double nested set of NOT EXISTS SELECT statements,a row that does not match any row matches every row.

When decreasing cardinalities,there will always be data loss.

Why do databases need redesigning?

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters