Database Redesign
Which of the following SQL statements are helpful in database redesign?

None of these
Correlated subqueries only
Both of the above are helpful
EXISTS/NOT EXISTS expressions only

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Changing cardinalities in a database is:

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

ANSWER DOWNLOAD EXAMIANS APP