Database Redesign

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

A:

data modeling.

B:

database design.

C:

reverse engineering.

D:

None of the above is correct.

Answer: C

No answer description is available. Let's discuss.

📖

Which SQL-92 standard SQL command can be used to change a table name?

A:

RENAME TABLE

B:

CHANGE TABLE

C:

ALTER TABLE

D:

None of the above is correct.

Answer: D

No answer description is available. Let's discuss.

📖

Database redesign is not terribly difficult if the:

A:

database is structured.

B:

database is well-designed.

C:

database has no data.

D:

database is relatively small.

Answer: C

No answer description is available. Let's discuss.

📖

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

A:

MODIFY TABLE TableName DROP COLUMN ColumnName

B:

MODIFY TABLE TableName DROP ColumnName

C:

ALTER TABLE TableName DROP COLUMN ColumnName

D:

ALTER TABLE TableName DROP ColumnName

Answer: C

No answer description is available. Let's discuss.

📖

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

A:

Correlated subqueries only

B:

EXISTS/NOT EXISTS expressions only

C:

Both of the above are helpful

D:

None of the above are helpful.

Answer: C

No answer description is available. Let's discuss.

📖

Questions for: Database Redesign