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 a brief note on a distributed database?
Explain what is meant by the Drill up/down/by/through?
How would the developer describe variable by using referential data types?
What is meant by the Drill Through?
Briefly explains the three kinds of SQL commands?
Explain what are new in the BO 5.1?
Illustrates the term normalization?
Explain the Combined Query?
Explain the way to search for data in a linked list.
Illustrates the properties of Cursors in brief?
18,76,764
1926806 Asked
3,689
Active Tutors
1460856
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!