Fichas
Transactions
Fichas del conjunto (9)
- 1What does ACID stand for?ATOMIC
CONSISTENT
ISOLATED
DURABLE - 2Explain atomiceither the whole transaction is executed, or none is.
- 3Explain consistentdatabase constraints are preserved.
- 4Explain isolatedappears to the user as if only one
process executes at a time. - 5Explain durableeffects of a transaction do not get lost if the system crashes.
- 6What is ROLLBACK? Give en example of what can cause a ROLLBACK. What effect does ROLLBACK have on the database?ROLLBACK causes the transaction to end, but by aborting.
Failures like division by 0 can also cause rollback, even if the programmer does not request it.
No effects on the database. - 7What does JDBC stand for?Java Database Connectivity
- 8What problems does Logging prevent?Logging only prevents problems related to de-synchronization with main memory.
- 9How many isolation levels are there in SQL?SQL defines four isolation levels = choices about what interactions are allowed by transactions that execute at about the same time.
Información
- Descripción
- 1 Database Fichas sobre Transactions, creado por linneamd el 15/03/2016.
- Creado por
- linneamd
- Visitas
- 2
- Valoración