Multiple Choice
Which of the following is not true about locks?
A) Locks with large granularity are easier for the DBMS to administer.
B) Locks with small granularity cause more conflicts.
C) Locks may have a database-level granularity.
D) Locks may have a table-level granularity.
Correct Answer:
Verified
Correct Answer:
Verified
Q1: Measures that are taken to prevent one
Q2: Recovering a database via reprocessing involves _.<br>A)restoring
Q3: Which type of lock still allows other
Q5: One remedy for the inconsistencies caused by
Q6: Ensuring that all rows impacted by the
Q7: Which of the following would a DBA
Q8: Recovering a database via rollforward involves _.<br>A)restoring
Q9: Resource locking must be carefully planned because
Q10: The security provided by the DBMS often
Q11: According to ANSI SQL,the serializable isolation level