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.
Provide a brief differentiation between independent and dependent data warehouse?
Explain metrics folders in brief?
Briefly explain continuous and discrete data in data mining?
What is the main reason that database is considered as "self-describing"?
Illustrates the types of Data Independence?
Describe briefly the term SQL Server Analysis Services cubes?
Write about the independent and dependent data marts.
Specify different types of transformations available in the Informatica?
Illustrates the third normal form?
Can we have a report with several data providers?
18,76,764
1949608 Asked
3,689
Active Tutors
1453077
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!