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