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.
State the difference between OLTP and OLAP?
State difference between the Stand–alone and the Embedded filter?
What is the simplest sorting method to utilize in data structures?
Describe briefly the term data warehouse?
Describe briefly three types of binary relationships in DBMS?
Write down a short note on the difference between partial specialization and total specialization.
What demerits of ODBC does OLE DB overcome?
Illustrates the TDS protocol in Sybase?
Briefly describe the employed of data cube?
Give brief introduction of the term breakpoint in SSIS?
18,76,764
1951769 Asked
3,689
Active Tutors
1419405
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!