Ch10/11 STUFF

cit 214 // all lower case answers

9 cards·by ross.muron

Equivalent of a single SQL statement in an application program or transaction

database request

state in which all data integrity constraints are satisfied

consistent state

transaction property where all operations of a transaction must be completed

atomicity

transaction propery where concurrent execution of several transactions yields consistent results

serializability

when two concurrent transactions update same data element, it is referred as a...

lost update

When 2 transactions occur concurrently, and one is rollback'd after the second accessed uncommitted data, it is refereed to as a...

uncommitted data

Shared, reserved, memory: also referred as a buffer cache

data cache

Storage of most recently executed SQL statements: also referred as a procedure cache

sql cache

What kind of optimizer has: algorithms based on statistics about objects being accessed

cost-based