WorksheetsCh5_Database Transaction Management
Total questions: 15
Worksheet time: 9mins
Choose the type of processing system that has time delay between the actual event and the transaction process.
Real Time Transaction Processing System
Batch Processing System
Online Transaction Processing System
Automatic Transaction Processing System
Choose the suitable description of Real Time Transaction Processing System.
Perform simultaneous input, process and output without requring access to online database
Facilitate and manage online transaction-oriented applications
Allow users to manage data at their own site
Accumulate multiple transaction over a period of time and process it as a single unit
Choose the DISADVANTAGE of OLTP
It is a tedious, complex and expensive processing.
Database is more suseptible to intruders because of its online availability.
The database may not always kept up to date.
Processing could be slow due to one time processing over time.
Choose the correct description of A.C.I.D in database transaction
Atomicity, Consistency, Integrity,
Dynamic
Atomicity, Confidential, Isolation,
Durability
Atomicity, Consistency, Isolation,
Durability
Atomicity, Consistency, Informative,
Durability
"No transaction will affect the existence of any other transaction."
This statement describe the ___________ properties in database transaction.
Isolation
Confidential
Integrity
Atomicity
"There must be no state in a database where a transaction is left partially completed."
This statement explains...
Durability
Atomicity
Isolation
Integrity
Choose the command use in transaction
I - Start Transaction
II - Commit
III - Join
IV - Rollback
I , II , III
I , II , IV
I , III , IV
II , III , IV
The following are purpose of concurrency control EXCEPT...
Prevent two different users from updating the same data at the same time
Maximize transaction throughput while preventing interference among multiple users
Ensure consistency of transactions in a multi-user environment
Prevent user from accessing data directly from the server
Ali and Wong select the same data and update the data based on the original values resulting that Ali's update overwrite Wong's update. This problem is called ...
Lost Data
Uncommitted Dependency
Lost Update
Inconsistent retrieval
The 'COMMIT' command in SQL means
Make the changes permanent in the database
Start the transaction in database
Undo the command to get back previous data
Make temporary changes in database
Locks granularity means....
number of users allowed to access the database
way to unlock the database
information about the locking system used in database
how much level of the data is locked at one time
Choose the CORRECT statement about lock types in concurrency control.
Shared lock can update and share lock on multiple item
Shared lock can update item in database
Exclusive lock can be granted when a shared lock is held oon the data
Exclusive lock can perform both read and update item
Choose the CORRECT phases in Two Phase Locking protocol.
Expanding and Shrinking
Expanding and Growing
Shrinking and Expanding
Growing and Multiplying
Choose the CORRECT statement for Deadlocks.
Deadlock allows multiple user secure item in database
Deadlock is good for database security
Deadlock occurs when all processes wait for each other to release resources
System in deadlock cannot be rolled back
How does transaction log functions in transaction recovery management? The log keeps track of all transaction operations that affect the values of database items.
Transaction log keep track of all transaction operation in database item
Transaction log restore database to a correct state in all failure event
Transaction log provides backup to restore and recover data
Transaction log rocover all deleted data in external devices
