DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database has no data.

database is structured.

database is well-designed.

database is relatively small.

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process is a true logical model.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

Which is not true of a correlated subquery?

The processing of the SELECT statements is nested.

EXISTS/NOT EXISTS is a form of a correlated subquery.

They can be used to verify functional dependencies.

They are very similar to a regular subquery.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTER TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

↑