What is a database transaction?
A transaction is a group of database operations treated as one logical unit.
Study 6 Transactions and Concurrency Basics with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
What is a database transaction?
A transaction is a group of database operations treated as one logical unit.
What does atomicity guarantee?
Atomicity means all operations in a transaction take effect, or none do; uncommitted changes can be rolled back.
What does consistency mean in ACID?
Consistency means a transaction preserves defined database rules, such as constraints and business rules.
What does isolation control?
Isolation controls which changes concurrent transactions can see and aims to prevent unacceptable interference.
What does durability guarantee?
Durability means successfully committed changes are recorded to survive system failure, subject to database guarantees and configuration.
What does `BEGIN` do?
`BEGIN` (or `START TRANSACTION`) starts a transaction block.
What does `COMMIT` do?
`COMMIT` makes a transaction's changes permanent and visible to other transactions.
What does `ROLLBACK` do?
`ROLLBACK` cancels a transaction's uncommitted changes.
How does a savepoint help within a transaction?
A `SAVEPOINT` marks a position in a transaction. `ROLLBACK TO SAVEPOINT` undoes work after that point while retaining earlier work.
What is autocommit?
With autocommit, each standalone statement is treated as its own transaction and committed if it succeeds.
Why group several related statements in a transaction?
Explicitly group statements in a transaction when they must succeed or fail together; autocommit otherwise treats standalone statements separately.
What are four common isolation-level names?
Common isolation-level names are `READ UNCOMMITTED`, `READ COMMITTED`, `REPEATABLE READ`, and `SERIALIZABLE`.
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
A structured guide to the main data structures, their operations, efficiency trade-offs, representations, and practical selection criteria.
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
A focused review of propositional logic, quantifiers, sets, relations, functions, and foundational proof methods in discrete mathematics for computer science.
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.