Q.1

Changing cardinalities in a database is:

  • a common database design task.
  • a rare database design task, but does occur.
  • a database design task that never occurs.
  • is impossible to do, so a new database must be constructed and the data moved into it.
Q.2

Which of the following modifications may not succeed?

  • Changing a column data type from char to date
  • Changing a column data type from numeric to char
  • Both of the above actions should succeed.
  • Neither of the above actions will succeed.
Q.3

How can you find rows that do not match some specified condition?

  • EXISTS
  • Double use of NOT EXISTS
  • NOT EXISTS
  • None of the above is correct.
Q.4

What SQL command can be used to delete columns from a table?

  • MODIFY TABLE TableName DROP COLUMN ColumnName
  • MODIFY TABLE TableName DROP ColumnName
  • ALTER TABLE TableName DROP COLUMN ColumnName
  • ALTER TABLE TableName DROP ColumnName
Q.5

A tool that can help designers understand the dependencies of database structures is a:

  • dependency graph.
  • data model.
  • graphical display.
  • None of the above is correct.
Q.6

How many copies of the database schema are typically used in the redesign process?

  • One
  • Two
  • Three
  • Four
Q.7

The NOT EXISTS keyword will be true if:

  • any row in the subquery meets the condition.
  • all rows in the subquery fail the condition.
  • both of these two conditions are met.
  • neither of these two conditions is met.
Q.8

Information systems and organizations do not just influence each other; they create each other.

  • True
  • False
Q.9

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

  • True
  • False
Q.10

The SQL-92 command to change a table name is RENAME TABLE.

  • True
  • False
Q.11

A regular subquery can be processed:

  • from the top down.
  • from the bottom up.
  • by nesting.
  • None of the above is correct.
Q.12

A correlated subquery is processed as a nested subquery.

  • True
  • False
Q.13

Database redesign is not terribly difficult if the:

  • database is structured.
  • database is well-designed.
  • database has no data.
  • database is relatively small.
Q.14

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

  • optimistic
  • skeptical
  • ambivalent
  • None of the above is correct.
Q.15

The data model that is produced from reverse engineering is:

  • a conceptual model.
  • an internal model.
  • a logical model.
  • None of the above is correct.
Q.16

To drop a column that is used as a foreign key, first:

  • drop the primary key.
  • drop the table containing the foreign key..
  • drop the foreign key constraint.
  • All of the above must be done.
Q.17

Adding null columns to a table is straightforward.

  • True
  • False
Q.18

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

  • True
  • False
Q.19

Reverse engineering is the process of reading a database schema and producing a data model from that schema.

  • True
  • False
Q.20

What SQL command can be used to add columns to a table?

  • MODIFY TABLE TableName ADD COLUMN ColumnName
  • MODIFY TABLE TableName ADD ColumnName
  • ALTER TABLE TableName ADD COLUMN ColumnName
  • ALTER TABLE TableName ADD ColumnName
0 h : 0 m : 1 s