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.
Why is modeling time-dependent data important with a time stamp?
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
Explain Triggers and Rules?
Give a brief introduction of the term non-additive facts?
Write down the latest error handling technique in SQL Server 2005?
Write down a short note on XML and also describe the uses of it?
Explain the term Cognos Connection?
Define the CYCLE/NO CYCLE into a Sequence.
Explain how the Chasm trap is solved?
Explain the types of jobs we have within the Data stage?
18,76,764
1925229 Asked
3,689
Active Tutors
1423194
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!