If a cluster gets divided into multiple subclusters due to lack of communication between cluster nodes, what is the condition of the cluster?

Which command takes corrective action on a fragmented index?

A. ALTER INDEX REORGANIZE B. UPDATE INDEX REBUILD C. REINDEX DATABASE D. UPDATE STATISTICS

‘One of the potential advantages of Distributed Database Management Systems is improved reliability and availability.’

(a) The consistency and reliability aspects of transactions are due to the ‘ACIDity’ properties of transactions. Discuss each of these properties and how they relate to the concurrency control and recovery mechanisms. Give examples to illustrate your answer.