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 CYCLE/NO CYCLE into a Sequence.
Write down the enhanced features in the Teradata V2R5 and V2R6?
Explain what are new in the BO 5.1?
Explain Data Only Page Locking in Sybase.
States the term SnowFlake.
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Write down security domain in Business Objects?
Give a brief introduction of the term real time data-warehousing?
Explain the power center repository?
What do you mean by the term Open Server in the Sybase?
18,76,764
1948755 Asked
3,689
Active Tutors
1458386
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!