MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
An application developer can guard against certain snapshot anomalies by appending a ______ clause to the SQL select query. |
| A. | For update |
| B. | For read |
| C. | For write |
| D. | None of the mentioned |
| Answer» B. For read | |
| 2. |
Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as |
| A. | Read skew |
| B. | Update skew |
| C. | Write lock |
| D. | None of the mentioned |
| Answer» E. | |
| 3. |
When a transaction Ti attempts to update a data item, it requests a _________ on that data item. |
| A. | Read lock |
| B. | Update lock |
| C. | Write lock |
| D. | Chain lock |
| Answer» D. Chain lock | |
| 4. |
Under first updater wins the system uses a __________ mechanism that applies only to updates. |
| A. | Close |
| B. | Read |
| C. | Locking |
| D. | Beat |
| Answer» D. Beat | |
| 5. |
Lost update problem is |
| A. | Second update overwrites the first |
| B. | First update overwrites the second |
| C. | The updates are lost due to conflicting problem |
| D. | None of the mentioned |
| Answer» B. First update overwrites the second | |
| 6. |
Snapshot isolation is used to give |
| A. | Transaction a snapshot of the database |
| B. | Database a snapshot of the transaction |
| C. | Database a snapshot of committed values in the transaction |
| D. | Transaction a snapshot of the database and Database a snapshot of committed values in the transaction |
| Answer» E. | |
| 7. |
Snapshot isolation is a particular type of ______________ scheme. |
| A. | Concurrency-control |
| B. | Concurrency-allowance |
| C. | Redirection |
| D. | Repetition-allowance |
| Answer» B. Concurrency-allowance | |