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.
Write down the employ of incremental aggregation?
Explain the loops?
Write about the term APT_CONFIG within the data stage?
What do you mean by the term Open Server in the Sybase?
What are the difficulties faced by the database developer during implementing pre compiled statements?
Does System development life cycle changes when you use Teradata in place of Oracle?
Explain the designer objects?
Define the efficient data structure used within the internal storage representation in RDBMS?
Explain the term Database Server?
When must you seem de-normalization?
18,76,764
1946793 Asked
3,689
Active Tutors
1433601
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!