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.
Explain how in a relation a supertype or subtype is mapped?
Define the way of passing of variables to a SQL routine.
Explain the Filter transformation?
Explain the loops?
Does SDLC modify when you use the Teradata rather than Oracle?
Describe briefly the term Session and Batches?
Briefly explains the three kinds of SQL commands?
Write down the security level employed in BO?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Define the term OCI?
18,76,764
1944427 Asked
3,689
Active Tutors
1415494
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!