Which of the Following Is True About a Shared Lock

question 41

Multiple Choice

Which of the following is true about a shared lock?

• A) It is more restrictive than an implicit lock.
• B) It allows only two transactions to update a record simultaneously.
• C) It locks the item from all access.
• D) It allows reads to the locked item.
• E) It must use a two-phase locking scheme.

---

Definitions:

Treasury Bond

U.S. government debt instruments featuring fixed interest rates and long-term maturity periods exceeding ten years.

Subprime Mortgages

Loans granted to borrowers with poor credit histories, which carry higher interest rates than standard mortgages to compensate for the higher risk.

Mortgage-backed CDOs

Complex structured finance products that pool together cash flow-generating assets and repackages this asset pool into tranches that can be sold to investors, specifically focusing on mortgage-backed securities.

Variable Rate Loans

Loans with interest rates that can fluctuate over time based on an underlying benchmark rate or index.