Before any changes to database structure are attempted one should firs – McqOptions

MCQOPTIONS

1.	Before any changes to database structure are attempted one should first:
A.	clearly understand the current structure and contents of the database only.
B.	test any changes on a test database only.
C.	create a complete backup of the operational database only.
D.	All of the above should be done.
Answer» E.

Discussion

No Comment Found

Related MCQs

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
The data model produced from the reverse engineering process does not include intersection table data.
It is not easy to build a database correctly the first time.
Adding null columns to a table is straightforward.
The EXISTS keyword will be true if any row in the subquery meets the condition.
The data model produced from the reverse engineering process is a true logical model.
If a database is built correctly the first time, it will not have to be redesigned.
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Reverse engineering is the process of reading a database schema and producing a data model from that schema.