MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row. |
| A. | Table-level |
| B. | Page-level |
| C. | Row-level |
| D. | Field-level |
| Answer» E. | |
| 2. |
All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions. |
| A. | Scheduler |
| B. | DBMS |
| C. | Lock manager |
| D. | Locking agent |
| Answer» D. Locking agent | |
| 3. |
If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an __________ on all the records belonging to that file. |
| A. | Explicit lock in exclusive mode |
| B. | Implicit lock in shared mode |
| C. | Explicit lock in shared mode |
| D. | Implicit lock in exclusive mode |
| Answer» E. | |