Intermediate Quiz on ACID vs BASE in Database Transactions
Assess your understanding of ACID and BASE principles in database transactions.
Questions in this quiz
12 questions on Intermediate Quiz on ACID vs BASE in Database Transactions. Work through them here, then start the quiz to answer them and see your score.
1.Which of the following best describes the 'Atomicity' property in ACID transactions?
- AChanges are permanent once a transaction is committed.
- BData remains consistent before and after a transaction.
- CTransactions are processed in isolation.
- DAll operations in a transaction are completed; if not, none are.
2.In the context of BASE, what does 'Eventually Consistent' mean?
- AData is always consistent across all nodes.
- BData is consistent only after manual intervention.
- CData may be inconsistent temporarily but will become consistent eventually.
- DData is consistent only during transaction execution.
3.What is the main trade-off when using BASE over ACID?
- AHigher availability for lower consistency.
- BHigher isolation for lower durability.
- CHigher consistency for lower availability.
- DHigher atomicity for lower scalability.
4.Which ACID property ensures that once a transaction is committed, it remains so even in the event of a system failure?
- ADurability
- BConsistency
- CAtomicity
- DIsolation
5.How does the 'Soft State' property of BASE differ from ACID?
- AData is never lost.
- BTransactions are always isolated.
- CData may change without input.
- DData is always consistent.
6.Which of the following is a characteristic of ACID-compliant systems?
- ANo consistency
- BImmediate consistency
- CPartial consistency
- DEventual consistency
7.What does the 'Isolation' property in ACID ensure?
- ATransactions are always rolled back on failure.
- BTransactions are always committed.
- CTransactions do not interfere with each other.
- DTransactions are visible to others immediately.
8.In BASE, what does 'Basically Available' mean?
- AThe system is available only during peak times.
- BThe system is always available.
- CThe system guarantees availability even during failures.
- DThe system is available only after manual intervention.
9.Which scenario is best suited for a BASE system?
- ASocial media feeds where eventual consistency is acceptable.
- BBank transactions requiring strict consistency.
- CInventory management requiring immediate updates.
- DReal-time bidding systems with strict data requirements.
10.What is a potential downside of using ACID transactions?
- AHigher latency due to strict consistency requirements.
- BLack of data consistency.
- CInability to handle large-scale data.
- DData loss during transactions.
11.Which property of ACID is primarily responsible for preventing dirty reads?
- AAtomicity
- BIsolation
- CConsistency
- DDurability
12.Why might a developer choose a BASE system over an ACID system?
- ATo achieve higher availability and scalability.
- BTo ensure strict data consistency.
- CTo guarantee transaction durability.
- DTo maintain strict isolation of transactions.