Home
My Puzzles
FAQ
Report bug
Collected Puzzles
User listed puzzles
Random Puzzle
Log In/Out

Chapter 5 : Database Transaction Management

Suzana Binti Yusof - Politeknik Sultan Mizan Zainal Abidin, Dungun Terengganu, Malaysia

This puzzle will test understanding regarding the concept in database transaction management

1
2
 
3
         
   
4
               
5
     
6
                   
     
7
       
 
8
           
   
 
9
                 
 
10
             

Across
3.Database __________ is a copy of all or part of disk. It is used when the disk containing the database or log is damaged.
4.A ___________ is reached where all changes are aborted and the database is restored to a previous consistent state.
6.___________ is a series of actions to be taken on the database so that either all actions are completed successfully, or none of them can be completed.
7.Transaction _______ is a table that contains a history of database changes. The recovery manager uses the log table to recover from failures.
8.A ________ statement is reached where all changes are permanently recorded within the database.
9.________________ is the act of writing a checkpoint to log and writing log and database buffer to disk.
10.______________ will restore database to a known correct state after failure.
Down
1.If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the _________ property is violated and the database is no longer consistent.
2.This property ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure. it is refers to ________________ .
5._____________ control is a database management system (DBMS) concept that is used to address conflicts with the simultaneous accessing or altering of data that can occur with a multi-user system.

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!




Google
 
Web armoredpenguin.com

Copyright information Privacy information Contact us