DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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 ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

drop the foreign key constraint.

All of these

drop the primary key.

drop the table containing the foreign key.

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following modifications may not succeed?

Changing a column data type from char to date

Neither of the above actions will succeed

Changing a column data type from numeric to char

Both of the above actions should succeed

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Changing cardinalities in a database is:

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

a common database design task.

a database design task that never occurs.

a rare database design task, but does occur.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑