DATABASE REDESIGN QUIZ

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 ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

data modeling.

reverse engineering.

database design.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if:

all rows in the subquery fail the condition.

both of these two conditions are met.

neither of these two conditions is met.

any row in the subquery meets the condition.

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

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

True

False

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

Which SQL-92 standard SQL command can be used to change a table name?

None of these

CHANGE TABLE

ALTER TABLE

RENAME TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is well-designed.

database is structured.

database has no data.

database is relatively small.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑