The DBMS acts as an interface between what two components of an enterprise-class database system?

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.

The term Complete for a UML has the same meaning as which of the following for an EER diagram?

• [A] Overlapping rule
• [B] Disjoint rule
• [C] Total specialization rule
• [D] Partial specialization rule

................. allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.

• [A] Procedur
• [B] Trigger
• [C] Cursor
• [D] none

Changing cardinalities in a database is:

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

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

• [A] One
• [B] Two
• [C] three
• [D] four