ACID transaction in DBMS
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Expert
An ACID transaction is one which is durable, isolated, consistent, and atomic. Durable states that database alters are permanent. Consistency can signify either statement level or transaction level consistency. through transaction level consistency, a transaction might not see its own alters.
There are four transaction isolation stages which are as follows:
(a) Read committed. (b) Read uncommitted.(c) Repeatable read. (d) Serialization.
Atomic means it is functioned as a unit.
Define the term DataStage?
Describe briefly Recovering sessions?
States the term Sybase group.
Describe briefly the measure objects?
Provide a brief introduction of the term ‘Data warehousing ’?
Explain about a Cartesian product?
Give a brief introduction of the term data cleaning?
Explain the master/detail reports?
Can we stop and start one session in the concurrent batch?
Describe briefly reusable transformations?
18,76,764
1953156 Asked
3,689
Active Tutors
1445876
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!