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 terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Explain the stage variables?
Explain the power center repository?
Briefly describes the systems development life cycle.
Specify the several types of Strategies?
Give a brief note on the term degenerate dimension table?
Consider a MOVIEdatabase in which data is recorded about the movie industry. The data requirement an u will given me this solution
Explain what is meant by the Drill up/down/by/through?
Elucidate briefly the term metadata reporter?
Briefly describe the employ of aggregate tables and lookup tables?
18,76,764
1940024 Asked
3,689
Active Tutors
1428074
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!