Explain what is meant by a transaction. Why are transactions important units of operation in a DBMS?
What will be an ideal response?
Transaction: An action, or series of actions, carried out by a single user or application program,
which reads or updates the contents of the database. A logical unit of work that transforms the
database from one consistent state to another. Also the unit of concurrency and recovery control.
You might also like to view...
What is the value of y after the following statement is coded and executed, given that x = 25? Set y = sqrt(x)
a. 5 b. 25 c. 125 d. 0
Using the information gathered during fact-finding, develop a requirements checklist that includes examples in each of the five main categories.
What will be an ideal response?
A constant is a value that remains the same in an expression
Indicate whether the statement is true or false
What tool is used as part of the Windows installation process?
A) Device Manager B) SYSPREP C) BACKUP D) MSCONFIG