Database Redesign
The data model that is produced from reverse engineering is:

None of these
a conceptual model.
an internal model.
a logical model.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Before any changes to database structure are attempted one should first:

test any changes on a test database only.
create a complete backup of the operational database only.
All of these
clearly understand the current structure and contents of the database only.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
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.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Changing cardinalities in a database is:

a database design task that never occurs.
a common database design task.
is impossible to do, so a new database must be constructed and the data moved into it.
a rare database design task, but does occur.

ANSWER DOWNLOAD EXAMIANS APP