Submission Date:23-Feb-2011
Q-1. Explain the following questions in detail.
1. What is a transaction explain with example?
2. Draw a state diagram and discuss the typical states that a transaction goes through execution?
3. Explain all transaction property with suitable example?
4. What is transaction log? What are the typical kind of records in a transaction log?
5. Explain Transaction Control Statement of SQL with Syntax and Example?
Q-2. Fill in the Blanks.
1. Collection of operations (for example, all the operations involved in the paymet of telephone bill) that form a single logical unit of work are called_______________.
2. The ACID properties of a transactions are______, _______, _______and _________.
3. _______ means that either all operations of the transactions are reflected properly in the database or none are.
4. _______ means that execution of a transaction in isolation preserves the consistency of the database.
5. The ____ of the DBMS ensures the atomicity of each transaction.
6. Ensuring isolation property is responsibility of the _______ of the DBMS.
7. The SQL statements used for transaction control are _______, _______ and _______.
8. Transaction Log is a _______ of all _______ and the corresponding changes to the _________.
9. A Consistent database state is one in which all _________ constraints are satisfied.
Q-3. State Whether the following statements are true or false. Justify your answer
1. The effect of successfully completed transaction are permanently recorded in the database and must not lost because of subsequent failure.
2. The transaction consists of all the operations executed between the beginning and end of the transaction.
3. A transaction that is either committed or aborted is said to be terminated.
4. Atomic transaction is transaction in which either all actions associated with the transaction are executed to completion, or none are performed.
5. Log is a record of all transactions and corresponding changes to the database.
6. The DBMS automatically update the transaction log while executing transactions that modify the database.
7. A Transaction is said to be in committed state if it has partially committed, and it can be ensured that it will be never aborted.
8. A transaction is a program unit, which can either be embedded within an application program or can be specified interactively via a high-level query language such as SQL.
9. A transaction that changes the contents of the database must alter the database from one consistent state to another.
0 comments:
Post a Comment