DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if:

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

reverse engineering.

data modeling.

None of these

database design.

TRUE ANSWER : ?
YOUR ANSWER : ?

How many copies of the database schema are typically used in the redesign process?

Four

One

Two

Three

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

How can you find rows that do not match some specified condition?

NOT EXISTS

EXISTS

None of these

Double use of NOT EXISTS

TRUE ANSWER : ?
YOUR ANSWER : ?

Adding null columns to a table is straightforward.

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 regular subquery can be processed:

from the bottom up.

from the top down.

by nesting.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑