Home/Database/Managing Multiuser Databases

Managing Multiuser Databases MCQs

43 questionsDatabasePage 3 of 5

Practice free Managing Multiuser Databases multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 43 questions — no login required.

Question 19easy

What is the overall responsibility of the DBA?

⚑ Report ✎ Feedback

Question 20easy

Locks placed by the DBMS are called ________ .

⚑ Report ✎ Feedback

Question 21hard

Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

⚑ Report ✎ Feedback

Question 22hard

The overall responsibility of the DBA is to facilitate the development and use of the database.

⚑ Report ✎ Feedback

Question 23medium

The size of the lock is referred to as the lock granularity.

⚑ Report ✎ Feedback

Question 24medium

A durable transaction is one in which all committed changes are permanent.

⚑ Report ✎ Feedback

Question 25hard

An ACID transaction is one that is atomic, consistent isolated, and durable.

⚑ Report ✎ Feedback

Question 26hard

When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

⚑ Report ✎ Feedback

Question 27medium

The size of a lock is referred to as lock sizing.

⚑ Report ✎ Feedback