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 with large granularity produce fewer details for the DBMS to track.
D) Locks may have a table-level granularity.
E) Locks may have a database-level granularity.
Correct Answer:
Verified
Correct Answer:
Verified
Q19: In regard to database security,neither the DBMS
Q37: When two transactions are being processed against
Q39: Recovering a database via reprocessing involves:<br>A)restoring the
Q41: Once processing rights have been defined,they may
Q43: Which type of lock prevents all types
Q46: Requiring all application programs to lock resources
Q47: Which of the following is allowed by
Q63: With pessimistic locking,the assumption is made that
Q83: The DBA is responsible for managing changes
Q92: Resources are locked for a shorter amount