SBM4302 Week 4 Quiz, T2, 2021

In the event of a disaster (disk failure, program error, malicious act), the DBMS can recover to an earlier version that is known to be correct.

• Agree

• Disagree

• Undecide

• No opnion

(a)   can use the contained application development software to create applications to access the database

Functions of the DBA include:

• Plan growth and change

• Implementation

• Maintenance

• All of the above

In a ___________IT unit is placed on “wait” status, if the intended item is already in use by other unit

• Centralized environment

• Decentralized environment

• Hub

• None of the above

These segments are distributed to their primary users. For example, the items A and B are stored locally at site 1.

• Partitioned

• Replicated

• Storage capacity

• Computer storage

It is possible for multiple sites to lock out each other from the database, thus preventing each from processing its transactions (deadlock)

• In a distributed environment

• In a centralised environment

• Partitioned

• Replicated

Terminate one or more transactions so that other transactions in the deadlock can be completed.

• Deadlock resolution

• Unlock resolution

• The partition approach

• All of the above

How to maintain current versions of these data at each site? (data concurrency problem)

• The replicated database approach

• The partition approach

Since data sharing is a fundamental objective of the database approach, this environment is vulnerable to damage from individual users

• Agree

• Disagree

• Not sure

• No opinion

Group transactions into classes to identify potential conflicts. For example, multiple sales order transactions involving both read and write operations will potentially conflict.

• Concurrency control

• Back up control

• Storage control

• Speed control