Which of the following SQL statements are helpful in database redesign?
Select an option to see the answer and solution.
Database · all questionsDatabase Redesign
Database Redesign
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
What SQL command can be used to delete columns from a table?
Select an option to see the answer and solution.
Database redesign is not terribly difficult if the:
Select an option to see the answer and solution.
Which SQL-92 standard SQL command can be used to change a table name?
Select an option to see the answer and solution.
The process of reading a database schema and producing a data model from that schema is known as:
Select an option to see the answer and solution.
Before any changes to database structure are attempted one should first:
Select an option to see the answer and solution.
Which of the following modifications may not succeed?
Select an option to see the answer and solution.
How can you find rows that do not match some specified condition?
Select an option to see the answer and solution.
A regular subquery can be processed:
Select an option to see the answer and solution.
What SQL command can be used to add columns to a table?
Select an option to see the answer and solution.
The EXISTS keyword will be true if:
Select an option to see the answer and solution.
Changing cardinalities in a database is:
Select an option to see the answer and solution.
The NOT EXISTS keyword will be true if:
Select an option to see the answer and solution.
The data model that is produced from reverse engineering is:
Select an option to see the answer and solution.
To drop a column that is used as a foreign key, first:
Select an option to see the answer and solution.
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?
Select an option to see the answer and solution.
Which is not true of a correlated subquery?
Select an option to see the answer and solution.
A tool that can help designers understand the dependencies of database structures is a:
Select an option to see the answer and solution.
How many copies of the database schema are typically used in the redesign process?
Select an option to see the answer and solution.
Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Select an option to see the answer and solution.