Chapter 6 - Database Administration || with 100% Accurate Solutions.
Data Administration correct answers an enterprise wide function that concerns the effective use and control of an organization's data assets. A person can perform it but more often it is performed by a group. Specific functions include setting data standards and policies and providing a forum for conflict resolution. Database Administration (DBA) correct answers a function that concerns the effective use and control of a particular database and its related application. Database administrator (DBA) correct answers A person or group responsible for establishing policies and procedures to control and protect a database. They work within guidelines set by data administration to control the database structure, manage data changes, and maintain DBMS programs Databases correct answers a self-describing collection of related records, or, for relational databases, of related tables. Concurrency control correct answers -Purpose: to ensure that one user's work does not inappropriately influence anther user's work. - No concurrency control technique or mechanism is ideal for all circumstances, all involve trade-offs. Transaction or Logical units of work (LUWs) correct answers a series of actions to be taken on a database such that all of them are performed successfully or none of them are performed at all Transaction is called atomic because correct answers it it performed as a unit. Concurrent transaction correct answers when two transactions are being processed against a database at the same time. Transactions are interleaved means correct answers the operating system switches cpu services among tasks The lost update problem or concurrent update problem correct answers an error condition in which one user's data changes are overwritten by another user's data changes. Inventory has 10 counts. - User A reduce count of item by 5 - User B reduce count of item by 3 Inventory should only have 2, but it display 7 ! Wrong Dirty Read is correct answers a read of data that have been changed but not yet committed to a database. Such changes may later be rolled back and removed from the database. - Transaction 1 read a row changed by transaction 2
Document information
- Uploaded on
- April 30, 2024
- Number of pages
- 3
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers