Exam 8: Database Redesign

When dropping a nonkey 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. )

To change a table name,we ________.

When dropping a primary 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. )

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

In the database redesign process,before proceeding with the redesign it is often useful to ________.

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

The use of a double nested set of NOT EXISTS SELECT statements is so rare that even if you are a professional database developer you will probably never see it used.

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

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.

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

The NOT EXISTS keyword will be true if any row in the subquery fails to meet the condition.

When running a correlated subquery,the DBMS ________.

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

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

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

Which of the following different copies of the database schema is/are typically used in the database redesign process?

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.

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

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

Adding new tables and relationships to a database is difficult.