• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 3 pages
Exam (elaborations)

Chapter 6 - Database Administration || with 100% Accurate Solutions.

Document preview thumbnail
Preview 1 out of 3 pages

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
March 15, 2024
Number of pages
3
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers
$10.57

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
SirAnton
3.7
(118)
Sold
810
Followers
438
Items
40067
Last sold
5 days ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.