Practice Database Redesign Multiple Choice Questions with Answers Quiz-3

Q.1.

Changing cardinalities in a database is:

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

Q.2.

Which of the following modifications may not succeed?

Changing a column data type from char to date
Changing a column data type from numeric to char
Both of the above actions should succeed.
Neither of the above actions will succeed.

Q.3.

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

EXISTS
Double use of NOT EXISTS
NOT EXISTS
None of the above is correct.

Q.4.

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

MODIFY TABLE TableName DROP COLUMN ColumnName
MODIFY TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP COLUMN ColumnName
ALTER TABLE TableName DROP ColumnName

Q.5.

A tool that can help designers understand the dependencies of database structures is a:

dependency graph.
data model.
graphical display.
None of the above is correct.

Q.6.

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

One
Two
Three
Four

Q.7.

The NOT EXISTS keyword will be true if:

any row in the subquery meets the condition.
all rows in the subquery fail the condition.
both of these two conditions are met.
neither of these two conditions is met.

Q.8.

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

True
False

Q.9.

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

True
False

Q.10.

The SQL-92 command to change a table name is RENAME TABLE.

True
False

Q.11.

A regular subquery can be processed:

from the top down.
from the bottom up.
by nesting.
None of the above is correct.

Q.12.

A correlated subquery is processed as a nested subquery.

True
False

Q.13.

Database redesign is not terribly difficult if the:

database is structured.
database is well-designed.
database has no data.
database is relatively small.

Q.14.

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

optimistic
skeptical
ambivalent
None of the above is correct.

Q.15.

The data model that is produced from reverse engineering is:

a conceptual model.
an internal model.
a logical model.
None of the above is correct.

Q.16.

To drop a column that is used as a foreign key, first:

drop the primary key.
drop the table containing the foreign key..
drop the foreign key constraint.
All of the above must be done.

Q.17.

Adding null columns to a table is straightforward.

True
False

Q.18.

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

True
False

Q.19.

Reverse engineering is the process of reading a database schema and producing a data model from that schema.

True
False

Q.20.

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

MODIFY TABLE TableName ADD COLUMN ColumnName
MODIFY TABLE TableName ADD ColumnName
ALTER TABLE TableName ADD COLUMN ColumnName
ALTER TABLE TableName ADD ColumnName

Support mcqgeeks.com by disabling your adblocker.