IT ENGLISH: Technical Terminology - ACID

What does the 'A' in ACID stand for?

• Atomicity

• Consistency

• Isolation

• Durability

Which characteristic ensures that each transaction is an 'all-or-nothing' event?

• Atomicity

• Consistency

• Isolation

• Durability

Which type of database tables are ACID-compliant in MySQL?

• InnoDB tables

• MyISAM tables

• Both InnoDB and MyISAM tables

• None of the above

What does the 'C' in ACID stand for?

• Atomicity

• Consistency

• Isolation

• Durability

Which characteristic ensures that only valid data is written to a database?

• Atomicity

• Consistency

• Isolation

• Durability

What does the 'I' in ACID stand for?

• Atomicity

• Consistency

• Isolation

• Durability

Which characteristic ensures that each transaction is handled individually?

• Atomicity

• Consistency

• Isolation

• Durability

What does the 'D' in ACID stand for?

• Atomicity

• Consistency

• Isolation

• Durability

Which characteristic guarantees that data will be stored once a transaction has been processed?

• Atomicity

• Consistency

• Isolation

• Durability

Which hardware component can prevent data loss in case of a power outage?

• RAID storage configuration

• UPS battery backup

• Both RAID storage configuration and UPS battery backup

• None of the above