DATABASE REDESIGN QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

The data model that is produced from reverse engineering is:

None of these

a logical model.

an internal model.

a conceptual model.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTER TABLE

None of these

CHANGE TABLE

RENAME TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Typically, there should be at least two different copies of the database schema used in the redesign process.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Some organizations take the stand that no application should ever employ the true name of a table.

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

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

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

↑