Short Answer
|
|
|
1.
|
What
is the difference between the front-end and the back-end in a database application?
|
|
|
2.
|
How
is the INSERT syntax different from the UPDATE syntax?
|
|
|
3.
|
What
is a transaction and why are they important?
|
|
|
4.
|
How
can transactions be done if you are using an Access database?
|
|
|
5.
|
What
does the term isolation mean with regard to transactions?
|
|
|
6.
|
What
is a phantom and what can cause it?
|
|
|
7.
|
If
concurrency is such a problem, why don't database applications just allow one user a time to make
changes in the data?
|
|
|
8.
|
What
similarities do you see between the SQL Server and the Oracle code shown above to rollback a
transaction based on an error?
|
|
|
9.
|
How
is locking handled by both back-ends and front-ends?
|
|
|
10.
|
What
are some ways to prevent deadlocks from occurring?
|