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.
Give brief introduction of the term breakpoint in SSIS?
Briefly explain continuous and discrete data in data mining?
Explain what needs to happen to convert a relation to third normal form?
Why recursive relationships are not good? How do you solve them?
State the different types of the folders?
Explain the term local container and shared container?
Name the major components of .NET Framework?
Illustrates the term heap in data structures?
Illustrates the term data structure node class?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
18,76,764
1951723 Asked
3,689
Active Tutors
1423673
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!