NTA-UGC-NET 2021 Dec & 2022 June Paper-1
April 14, 2024UGC NET CS 2012 June-Paper2
April 14, 2024UGC NET CS 2012 June-Paper2
| Question 7 |
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by
| Jamming | |
| Password | |
| Documentation | |
| Record lock |
Question 7 Explanation:
→ In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by record lock.
→ Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.
→ A simple way to prevent this is to lock the file whenever a record is being modified by any user, so that no other user can save data. This prevents records from being overwritten incorrectly, but allows only one record to be processed at a time, locking out other users who need to edit records at the same time.
→ Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.
→ A simple way to prevent this is to lock the file whenever a record is being modified by any user, so that no other user can save data. This prevents records from being overwritten incorrectly, but allows only one record to be processed at a time, locking out other users who need to edit records at the same time.
Correct Answer: D
Question 7 Explanation:
→ In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by record lock.
→ Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.
→ A simple way to prevent this is to lock the file whenever a record is being modified by any user, so that no other user can save data. This prevents records from being overwritten incorrectly, but allows only one record to be processed at a time, locking out other users who need to edit records at the same time.
→ Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.
→ A simple way to prevent this is to lock the file whenever a record is being modified by any user, so that no other user can save data. This prevents records from being overwritten incorrectly, but allows only one record to be processed at a time, locking out other users who need to edit records at the same time.