Skillcert 4

Question 1

What is s transactions

hat encapsulate specific events that the organization wants to track

Yes or not

Answer 1

yes

Question 2

What is Online Transactional Processing (OLTP)

The work performed by transactional systems

Yes or not

Answer 2

Yes

Question 3

What are ACID Semantics

Atomicity
consistency
Isolation
accountability

Yes or no

Answer 3

NO
Atomicity
consistency
Isolation
Durability

Question 4

Atomicity

each transaction is treated as a single unit, which succeeds completely or fails completely. For example, a transaction that involved debiting funds from one account and crediting the same amount to another account must complete both actions. If either action can’t be completed, then the other action must fail.

Yes or not

Answer 4

Yes

Question 5

Consistency

transactions can only take the data in the database from one valid state to another. To continue the debit and credit example above, the completed state of the transaction must reflect the transfer of funds from one account to the other.

Yes or not

Answer 5

Yes

Question 6

Isolation

oncurrent transactions cannot interfere with one another, and must result in a consistent database state. For example, while the transaction to transfer funds from one account to another is in-process, another transaction that checks the balance of these accounts must return consistent results - the balance-checking transaction can’t retrieve a value for one account that reflects the balance before the transfer, and a value for the other account that reflects the balance after the transfer.