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 short note on the differences between vertical and horizontal portioning?
Will I find several users to network with, if I use NetLib? Answer: NetLib has been around in 1986, and has over users that are 20,000, world-wide. You will simply f
Name the triggers which support SQL Server 2000?
How teradata ensures that there are no duplicate rows being inserted while this SET table?
Explain the mapping of ERD to DFD?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Illustrates the third normal form?
Illustrates the quickest sorting method to use?
Specify the types of connections we use while connecting with the database?
Explain the connected and unconnected transformation?
18,76,764
1936853 Asked
3,689
Active Tutors
1443624
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!