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.
Illustrate out some of the standard Business Intelligence tools in the market?
Elucidate what are the tasks which Load manger process will do?
Illustrate the term indexing. Specify the kinds of the indexing.
Explain the Expression transformation?
Describe the term HOLAP.
What is an Operational Data Store?
How simple is NetLib to utilize?
Illustrate the main merits of employing stored procedures?
How can we do unit testing into the informatica? How to load data in the informatica?
Define the class?
18,76,764
1929013 Asked
3,689
Active Tutors
1438617
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!