Database Redesign MCQs with Explanations

Both of the above are helpful is the correct answer to “Which of the following SQL statements are helpful in database redesign”. This question is standard in competitive examination syllabi for Database Redesign.

ALTER TABLE TableName DROP COLUMN ColumnName is the correct answer to “What SQL command can be used to delete columns from a table”. This question is standard in competitive examination syllabi for Database Redesign.

database has no data. is the correct answer to “Database redesign is not terribly difficult if the:”. This question is standard in competitive examination syllabi for Database Redesign.

None of the above is correct is the correct answer to “Which SQL-92 standard SQL command can be used to change a table name”. This question is standard in competitive examination syllabi for Database Redesign.

reverse engineering. is the correct answer to “The process of reading a database schema and producing a data model from that schema is known as:”. This question is standard in competitive examination syllabi for Database Redesign.

All of the above should be done. is the correct answer to “Before any changes to database structure are attempted one should first:”. This question is standard in competitive examination syllabi for Database Redesign.

Changing a column data type from char to date is the correct answer to “Which of the following modifications may not succeed”. This question is standard in competitive examination syllabi for Database Redesign.

Double use of NOT EXISTS is the correct answer to “How can you find rows that do not match some specified condition”. This question is standard in competitive examination syllabi for Database Redesign.

from the bottom up. is the correct answer to “A regular subquery can be processed:”. This question is standard in competitive examination syllabi for Database Redesign.

ALTER TABLE TableName ADD ColumnName is the correct answer to “What SQL command can be used to add columns to a table”. This question is standard in competitive examination syllabi for Database Redesign.

any row in the subquery meets the condition only. is the correct answer to “The EXISTS keyword will be true if:”. This question is standard in competitive examination syllabi for Database Redesign.

a common database design task. is the correct answer to “Changing cardinalities in a database is:”. This question is standard in competitive examination syllabi for Database Redesign.

all rows in the subquery fail the condition. is the correct answer to “The NOT EXISTS keyword will be true if:”. This question is standard in competitive examination syllabi for Database Redesign.

None of the above is correct. is the correct answer to “The data model that is produced from reverse engineering is:”. This question is standard in competitive examination syllabi for Database Redesign.

drop the foreign key constraint. is the correct answer to “To drop a column that is used as a foreign key, first:”. This question is standard in competitive examination syllabi for Database Redesign.

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0) is the correct answer to “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”. This question is standard in competitive examination syllabi for Database Redesign.

They are very similar to a regular subquery. is the correct answer to “Which is not true of a correlated subquery”. This question is standard in competitive examination syllabi for Database Redesign.

dependency graph. is the correct answer to “A tool that can help designers understand the dependencies of database structures is a:”. This question is standard in competitive examination syllabi for Database Redesign.

Three is the correct answer to “How many copies of the database schema are typically used in the redesign process”. This question is standard in competitive examination syllabi for Database Redesign.

skeptical is the correct answer to “Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “A correlated subquery is processed as a nested subquery.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “A regular subquery is processed from the bottom up.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “Correlated subqueries are similar to a regular subquery.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “Database redesign is especially difficult if the database has no data.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “Some organizations take the stand that no application should ever employ the true name of a table.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “Although creating test databases is a critical and necessary job, there are few career opportunities in this area.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “The data model produced from the reverse engineering process does not include intersection table data.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “If a database is built correctly the first time, it will not have to be redesigned.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “The SQL-92 command to change a table name is RENAME TABLE.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “Reverse engineering is the process of reading a database schema and producing a data model from that schema.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “The data model produced from the reverse engineering process is a true logical model.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “It is not easy to build a database correctly the first time.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “Typically, there should be at least two different copies of the database schema used in the redesign process.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “Information systems and organizations do not just influence each other; they create each other.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “Adding null columns to a table is straightforward.”. This question is standard in competitive examination syllabi for Database Redesign.

False is the correct answer to “The NOT EXISTS keyword will be true if any row in the subquery meets the condition.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.”. This question is standard in competitive examination syllabi for Database Redesign.

True is the correct answer to “The EXISTS keyword will be true if any row in the subquery meets the condition.”. This question is standard in competitive examination syllabi for Database Redesign.