Get the job you dream on
 

Welcome to our job seeking Archive. Have fun browsing!

 

Article #170: Sql Server Interview Questions on File Server and Client Server Database

(Browse for more articles)

 
One of major things in two of this are the best suit example of client
approach is of working with data but both server databases. Single user desktop
of these works in different manner. just like Microsoft access.
In File Server Database approach the data There are lots of advantages of client
is stored in the file and user have to server databases.
take data directly from the file. When 1) Single program reading and writing
any change is to be made it is directly data the less chance of accidental
on the file application that is open .The changes or crashes of data. 2) Only
file and data writes to these files. If single program play good role of security
10 users are online on data then 10 are so enforcement of security is easy. 3)
working and writing on the file. Client server databases use network
In a client server approach data is still bandwidth more efficiently then file
stored in a file but controlled by a server databases. 4) All things are
server all the access in the hand of handling by single computes so
server. When any of application wants to performance is good and quite impressive.
make use of existing data then 5) Client-servers databases use some
application request is send to server. good features that protect our data just
After that server reads the request and like logging transactions and recovery
send feedback. When any of application from disk and network errors.
wants to writes something on file the Some of these features are also available
request is send to server the server in file server approach but these need
writes on the file. One single person more expensive client server market. You
reads and writes from this data files. can also learn more on dot net interview
Oracle, Informix, Microsoft Sql Server questions.






1 - A - B - C - D - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 20 - 21 - 22 - 23 - 24 - 25 - 26 - 27 - 28 - 29 - 30 - 31 - 32 - 33 - 34 - 35 - 36 - 37 - 38 - 39 - 40 - 41 - 42 - 43 - 44 - 45 - 46 - 47 - 48 -