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.
Explain the way to unzip a File in SSIS.
Justify whether all the Business Objects users build the data providers?
Describes the difference between NULL and VOID pointers into Data Structures?
Explain several of the products of Sybase?
Give a brief introduction of the term dicing and slicing in business objects?
Explain how do I choose which Tables to Partition in the Sybase?
Provide a brief differentiation between independent and dependent data warehouse?
State the different advantages of the data warehousing?
Explain and compare OBE and SQL?
What are cliques?
18,76,764
1938323 Asked
3,689
Active Tutors
1422310
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!