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...
In the case of a forest trust, both forests must be operating at the Windows Server 2008 or higher forest functional level
Indicate whether the statement is true or false
Case-Based Critical Thinking QuestionsCase 7-2RockCats is a Double A baseball team that has created a Web site to provide people with information about them as well as game dates, practice pictures, and game clips. Each team member has a picture and a video. To set it up so that either the video or the picture displays, they could use a(n) ____ if they knew their audience uses Internet Explorer.
A. conditional comment B. optional source C. dynamic resource D. Flash source