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.

SQL queries that use EXISTS and NOT EXISTS are ________.

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

The process of reading an actual database schema and producing a data model from that schema is called ________.

When dropping tables and relationships,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 order to make sure the database redesign is working properly during the redesign testing process,a means must be created to ________.

What is a correlated subquery?

Which of the following is not a possible step in the database redesign process?

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

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

In a real sense,information systems and organizations do not just influence each other,but rather they create each other.

Database redesign is rarely needed because databases are usually built correctly the first time.

In a correlated subquery of a database that has tables TableOne and TableTwo,if table TableOne is used in the upper SELECT statements,then which table is used in the lower SELECT statement?

What is the process and what are the considerations when changing a table name?

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

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

The data model produced by reverse engineering is a(n)________.

When running a correlated subquery,the DBMS ________.

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

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