1.3.2 Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What is the SQL Statement?

A

SELECT
FROM
WHERE

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

What is Atomicity?

A

The transaction must be completed fully or not done at all

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

What is Consistency?

A

Any change must not break the database

It must be consistent with how it was before change

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

What is isolation?

A

A transaction must be isolated and not interfere with another transaction

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

What is durability?

A

A transaction must remain in the database

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