What are the advantages of client/server databases over personal databases in multi-user environment?
What will be an ideal response?
In the multi-user client/server environment, when a client is using a table, the
database locks that table partly or wholly to avoid simultaneous transactions on
the same record. The programmer does not have to write code for the table
locking. When a client fails, it does not affect the other clients.
In the multi-user personal database system, the ‘optimistic locking’ is used. The
system assumes that no two simultaneous transactions will happen on the same
record. The database system does not lock tables automatically, but the
programmer has to write routines for table locking and unlocking. When a client
fails, it may force other clients to exit the system for the database repair operation.
You might also like to view...
Positive ____ come out of the page toward users, while negative values recede away from users.
A. z-values B. x-values C. y-values D. q-values
Templates may be used to make available a very large collection of _____.
a) programs b) classes c) files b) classese) none of the above. C++ doesn't support templates.
________ applies unique fonts, font sizes, font colors, and font attributes to your characters
Fill in the blank(s) with correct word
What technology is needed to transfer data from a DVR to a DVD in a PC?
A) LCD controller B) Inverter C) Capture card D) KVM switch