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.
Why Increase correct timeslice -201?
Specify the difference between the ER Modeling and Dimensional Modeling?
Elucidate how many kinds of dimensions are accessible in the Informatica?
Explain, what are Dimensional table?
Name four applications which are employing for triggers in DBMS?
What is meant by the User Objects? Specify some of its restrictions?
How simple is NetLib to utilize?
State the difference between the class and universe?
Where is the GRANT table option usually done after creating tables dynamically within the Teardata? While tables are newly created, what are the default role and default privileges that get assigned?
Explain the command line functions which export and import the DS jobs?
18,76,764
1929367 Asked
3,689
Active Tutors
1456646
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!