Sign in to save your progress, vote, and build your own decks.Sign in
Magic
The Gathering
11 cards·by Winter
What is a "query optimizer"?
The Optimizer find the most efficient way to access the data through parsing the activities.
What is Atomicity?
When all operations of a transaction must be completed
Define Consistency
The permanence of a database’s consistent state
Explain Isolation
When the data that is used during a transaction cannot be used by a second transaction until the
first is completed.
What is Durability?
It means that once transactions are committed, they cannot be undone.
What is Serializability?
The Concurrent execution of several transactions yields consistent results.
Define Data sparsity
The number of different values a column could possibly have.
What are Optimizer Hints?
Special instructions for the optimizer embedded in the SQL command text
Explain what are Input/output requests?
They are low-level data access operation to/from computer devices
What is the atomic transaction property?
All portions of the transaction must be treated as a single, logical unit of work in which all
operations are applied to produce consistancy
Define Scarf
A piece of fabric worn around the neck, or to take food, often not belonging to you, for the
purpose of immediate consumption.