Multiple choice technology web technology

cluster member has suddenly crashed. The administrator is concerned about aborted transactions holding locks in the database. What can an administrator do to release the locks?

  1. Unmount the shared file system such as a Network Attached Storage (NAS) where thetransaction log is stored

  2. Restart the deployment manager and node agents who manage the transaction log

  3. Verify another running cluster member has access to the transaction log

  4. Reconnect the database where the transaction log is stored
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a cluster member crashes, locks held by its transactions must be released by another member with access to the transaction log for recovery. The transaction log contains the state of in-flight transactions. Options A, B, and D don't address transaction log access which is required for lock recovery in clustered environments.

Keep practicing — related questions