FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Database Redesign

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

When decreasing cardinalities,there will always be data loss.

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

Why do databases need redesigning?

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

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

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 contains an SQL command RENAME TABLENAME that can be used to change table names.

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

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

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

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

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

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.

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

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

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

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.

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