Question 1 of 25
Hints left: 3
Q1
An ideal primary key is short, numeric and seldom changing.
Q2
Before any changes to database structure are attempted one should first:
Q3
To drop a column that is used as a foreign key, first:
Q4
Which of the following SQL statements are helpful in database redesign?
Q5
Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Q6
A regular subquery can be processed:
Q7
Database redesign is not terribly difficult if the:
Q8
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Q9
The EXISTS keyword will be true if:
Q10
How can you find rows that do not match some specified condition?
Q11
When the parent entity is required, a new parent row can always be inserted.
Q12
Which of the following modifications may not succeed?
Q13
Which SQL-92 standard SQL command can be used to change a table name?
Q14
What SQL command can be used to delete columns from a table?
Q15
The NOT EXISTS keyword will be true if:
Q16
The data model that is produced from reverse engineering is:
Q17
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
Q18
Which is not true of a correlated subquery?
Q19
For every relationship, there are six possible referential integrity actions.
Q20
Changing cardinalities in a database is:
Q21
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Q22
How many copies of the database schema are typically used in the redesign process?
Q23
The process of reading a database schema and producing a data model from that schema is known as:
Q24
A tool that can help designers understand the dependencies of database structures is a:
Q25
What SQL command can be used to add columns to a table?