MIS 431: Transactions #1 Questions with Correct Answers

MIS 431: Transactions #1 Questions with Correct Answers
Transactions - ✔✔- Logical unit of work


- Must be either entirely completed or aborted


- No intermediate states are acceptable


Transactions Properties: Atomic - ✔✔- All transaction operations must be
completed


- Incomplete transactions aborted


Transactions Properties: Consistency - ✔✔Any transaction will take the db from
one consistent state to another, with no broken constraints (referential integrity)


Transactions Properties: Isolation - ✔✔Other operations can't access data that
has been modified during a transaction tat has not yet completed


Transactions Properties: Durability - ✔✔- Permanence of consistent database
state


- Ability to recover the committed transaction updates against any kind of system
failure (transaction log)


Transaction Management with SQL: Transaction support - ✔✔- COMMIT

, - ROLLBACK


Transaction Management with SQL: User initiated - ✔✔Transaction sequence
must continue until


- COMMIT statement is reached


- ROLLBACK statement is reached


- End of a program reached


- Program reaches abnormal termination


Transaction Log: Log stores - ✔✔- Record for beginning of transaction


- Each SQL statement


- Commit statement


Transaction Log: Log stores (Each SQL statement ) - ✔✔- Operations


- Names of objects