Skillcert 4 Flashcards

1
Q

What is s transactions

hat encapsulate specific events that the organization wants to track

Yes or not

A

yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Online Transactional Processing (OLTP)

The work performed by transactional systems

Yes or not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are ACID Semantics

Atomicity
consistency
Isolation
accountability

Yes or no

A

NO
Atomicity
consistency
Isolation
Durability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly