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 function of metadata for the three-layer architecture?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
In JDBC driver which coding pattern is use? Describe briefly?
Explain the Expression transformation?
Explain some of the data mining tools.
What is meant by the Data warehouse?
Write about the components of the Ascential Data Stage?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Explain how is the HASH file used and where we can use it?
State the types of users in the Business Objects?
18,76,764
1934078 Asked
3,689
Active Tutors
1438255
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!