CSE :: Database System 2 - CS
- Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
- The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
- The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
- Database administration refers to a function that applies to the entire organization.
- The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
- A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
- A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
- A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Whatsapp
Facebook
