When updating or inserting into a table, increased concurrency is obtained when granular locks are used, even when there are no indices. Explain why.
What will be an ideal response?
The only locks that need to be obtained are a SIX lock on the table (a read lock and an intention exclusive lock on the table) and a write lock on the rows inserted or updated.
Computer Science & Information Technology
You might also like to view...
Answer the following questions true (T) or false (F)
1. True/False: To obtain information from a database, a programmer or database administrator would use a query. 2. True/False: A rectangular grid of numbers (rows and columns) is known as a matrix. 3. True/False: The serial search cannot be used with a list of names.
Computer Science & Information Technology
When you filter by selection, you specify only one criterion for the filter.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology