DATABASE REDESIGN QUIZ

If a database is built correctly the first time, it will not have to be redesigned.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery is processed from the bottom up.

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

Which of the following modifications may not succeed?

Both of the above actions should succeed

Changing a column data type from char to date

Changing a column data type from numeric to char

Neither of the above actions will succeed

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process does not include intersection table data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL command can be used to delete columns from a table?

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Double use of NOT EXISTS

NOT EXISTS

EXISTS

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑