21. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
22. The overall responsibility of the DBA is to facilitate the development and use of the database. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
23. The size of the lock is referred to as the lock granularity. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
24. A durable transaction is one in which all committed changes are permanent. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
25. An ACID transaction is one that is atomic, consistent isolated, and durable. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
26. When one transaction reads a changed record that has not been committed to the database a filthy read occurs. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
27. The size of a lock is referred to as lock sizing. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
28. When two transactions are being processed against the database at the same time they are termed concurrent transactions. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
29. Locks placed by the DBMS are explicit locks. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
30. In optimistic locking, the assumption is made that conflict will occur. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board