Question
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.
Posted under Recovery System DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Before any changes to database structure are attempted one should first:
Similar Questions
Discover Related MCQs
Q. Which of the following modifications may not succeed?
View solution
Q. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
View solution
Q. Which of the following can cause a transaction failure
View solution
Q. If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________
View solution
Q. If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________
View solution
Q. If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as ________
View solution
Q. The assumption that the hardware errors bring the system to a halt is called as ________
View solution
Q. Which of the following is not a classification of storage
View solution
Q. If a failure has occurred in the midst of a transfer, it is called as _________
View solution
Q. State true or false: The destination block has incorrect information in case of a total failure
View solution
Q. The partitions of the database into fixed length storage units are called as __________
View solution
Q. The blocks residing on the disk are referred to as ___________
View solution
Q. The area of memory where blocks temporarily reside is called as ________
View solution
Q. The most widely used structure for recording database modification is called as _______
View solution
Q. An update log record describes a ________ database write
View solution
Q. Which of the following fields does the update log record have?
View solution
Q. The unique identifier of the transaction that performed the write operation is called as _______
View solution
Q. The value of the data item prior to the write is called as _________
View solution
Q. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
View solution
Q. We say that a transaction has been ________ when its commit log record has been output to stable storage.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
