DATABASE REDESIGN QUIZ

Database redesign is not terribly difficult if the:

database is relatively small.

database is well-designed.

database has no data.

database is structured.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is especially difficult if the database has no data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery can be processed:

by nesting.

from the top down.

from the bottom up.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Changing cardinalities in a database is:

a rare database design task, but does occur.

a common database design task.

a database design task that never occurs.

is impossible to do, so a new database must be constructed and the data moved into it.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

It is not easy to build a database correctly the first time.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model that is produced from reverse engineering is:

an internal model.

None of these

a logical model.

a conceptual model.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑