Understanding ACID vs BASE in Database Transactions
A beginner's quiz to differentiate between ACID and BASE properties in database transactions.
Questions in this quiz
15 questions on Understanding ACID vs BASE in Database Transactions. Work through them here, then start the quiz to answer them and see your score.
1.What does the 'A' in ACID stand for?
- AAdaptability
- BAvailability
- CAtomicity
- DAccuracy
2.Which of the following is a characteristic of BASE?
- AEventual consistency
- BStrict consistency
- CImmediate consistency
- DStrong consistency
3.In ACID, what does 'Consistency' ensure?
- ATransactions are isolated
- BData integrity is maintained
- CData is always available
- DTransactions are atomic
4.Which property of ACID ensures that transactions do not interfere with each other?
- ADurability
- BAtomicity
- CConsistency
- DIsolation
5.What does the 'D' in ACID stand for?
- ADependability
- BDurability
- CData
- DDistribution
6.Which of the following is NOT a BASE property?
- ABasically Available
- BEventual Consistency
- CSoft State
- DImmediate Consistency
7.What does 'Basically Available' mean in BASE?
- ASystem is available during transactions
- BSystem is sometimes available
- CSystem is always available
- DSystem is never available
8.Which ACID property ensures that once a transaction is committed, it will not be lost?
- AConsistency
- BAtomicity
- CIsolation
- DDurability
9.What is a key difference between ACID and BASE?
- ABASE is for relational databases
- BACID is for distributed systems
- CBASE provides strong consistency
- DACID provides strong consistency
10.Which database model is more suitable for high availability and scalability?
- ABASE
- BNeither
- CACID
- DBoth
11.In the context of databases, what does 'Eventual Consistency' mean?
- AData is consistent immediately
- BData is never consistent
- CData is always consistent
- DData becomes consistent over time
12.Which of the following is a focus of ACID transactions?
- AFlexibility
- BPerformance
- CScalability
- DReliability
13.What does 'Soft State' imply in BASE?
- AState may change over time
- BState is always consistent
- CState is immediately consistent
- DState is never consistent
14.Which property of ACID transactions ensures that all operations within a transaction are completed successfully?
- AIsolation
- BAtomicity
- CConsistency
- DDurability
15.Which of the following best describes BASE systems?
- AImmediate consistency
- BStrict consistency
- CLow availability
- DHigh availability