DATABASE REDESIGN QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

data model.

None of these

dependency graph.

graphical display.

TRUE ANSWER : ?
YOUR ANSWER : ?

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 : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following modifications may not succeed?

Neither of the above actions will succeed

Changing a column data type from numeric to char

Both of the above actions should succeed

Changing a column data type from char to date

TRUE ANSWER : ?
YOUR ANSWER : ?

If a database is built correctly the first time, it will not have to be redesigned.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The process of reading a database schema and producing a data model from that schema is known as:

database design.

reverse engineering.

data modeling.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑