Database Redesign Questions and Answers

Q: Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

Correct answer: FalseBuilding realistic test databases is a substantial specialism in its own right, requiring data that exercises the boundary conditions, respects the constraints, and is large enough to reveal performance problems - while often being anonymised for privacy. It is a recognised and well-paid area of database work, not a dead end.

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

Correct answer: ThreeThree copies are used: the operational schema, which is left untouched; a test copy on which the changes and their SQL are proved; and a copy carrying the proposed new design. Working with fewer means either testing against live data or having nowhere to develop the new structure, and the three-copy arrangement is what allows the change to be rehearsed completely before it is applied.

Q: The process of reading a database schema and producing a data model from that schema is known as:

Correct answer: reverse engineering.Reverse engineering works backwards from what exists: it reads the schema - tables, columns, keys, constraints - and produces a data model from it. Forward engineering runs the other way, generating a schema from a model. Reverse engineering is the first step in redesigning a database whose documentation is missing or has fallen out of step with what was actually built.

Q: The SQL-92 command to change a table name is RENAME TABLE.

Correct answer: FalseSQL-92 contains no rename command at all. RENAME TABLE is MySQL’s, and the other products each have their own, so a rename cannot be written portably. The standard-conforming route is to create the new table, copy the rows and drop the old one.

Q: Typically, exactly two different copies of the database schema are used in the redesign process.

Correct answer: FalseThree copies are used, not two: the operational schema, which is left alone; a test copy on which the changes are proved against representative data; and a copy carrying the proposed new design. With only two, either the testing is done against live data or there is nowhere to develop the new structure.

41.

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

A.True
B.False

Answer: B

Correct answer: False

Building realistic test databases is a substantial specialism in its own right, requiring data that exercises the boundary conditions, respects the constraints, and is large enough to reveal performance problems - while often being anonymised for privacy. It is a recognised and well-paid area of database work, not a dead end.

Discuss in Forum

42.

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

A.One
B.Two
C.Three
D.Four

Answer: C

Correct answer: Three

Three copies are used: the operational schema, which is left untouched; a test copy on which the changes and their SQL are proved; and a copy carrying the proposed new design. Working with fewer means either testing against live data or having nowhere to develop the new structure, and the three-copy arrangement is what allows the change to be rehearsed completely before it is applied.

Discuss in Forum

43.

The process of reading a database schema and producing a data model from that schema is known as:

A.data modeling.
B.database design.
C.reverse engineering.
D.None of the above is correct.

Answer: C

Correct answer: reverse engineering.

Reverse engineering works backwards from what exists: it reads the schema - tables, columns, keys, constraints - and produces a data model from it. Forward engineering runs the other way, generating a schema from a model. Reverse engineering is the first step in redesigning a database whose documentation is missing or has fallen out of step with what was actually built.

Discuss in Forum

44.

The SQL-92 command to change a table name is RENAME TABLE.

A.True
B.False

Answer: B

Correct answer: False

SQL-92 contains no rename command at all. RENAME TABLE is MySQL’s, and the other products each have their own, so a rename cannot be written portably. The standard-conforming route is to create the new table, copy the rows and drop the old one.

Discuss in Forum

45.

Typically, exactly two different copies of the database schema are used in the redesign process.

A.True
B.False

Answer: B

Correct answer: False

Three copies are used, not two: the operational schema, which is left alone; a test copy on which the changes are proved against representative data; and a copy carrying the proposed new design. With only two, either the testing is done against live data or there is nowhere to develop the new structure.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Database Redesign Questions and Answers || Database Redesign MCQ Questions and Answers || Database Redesign GK Questions and Answers || Database Redesign GK MCQ Questions || Database Redesign Multiple Choice Questions and Answers || Database Redesign GK || GK on Database Redesign || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Database Redesign Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications