eg: UK or Brides UK or Classical Art or Buy Music or Spirituality
 
eg: UK or Brides UK or Classical Art or Buy Music or Spirituality
 

Your Online Guide » Human Resource Career » Interview Questions and Answers

[S845]Sql Server Interview Questions And Answers
by Adam Sturo, Ada
In File Server Database approach the data is stored in the file and user have to take data directly from the file. When any change is to be made it is directly on the file application that is open .The file and data writes to these files. If 10 users are online on data then 10 are working and writing on the file.

In a client server approach data is still stored in a file but controlled by a server all the access in the hand of server. When any of application wants to make use of existing data then application request is send to server. After that server reads the request and send feedback. When any of application wants to writes something on file the request is send to server the server writes on the file. One single person reads and writes from this data files.

Oracle, Informix, Microsoft Sql Server are the best suit example of client server databases. Single user desktop just like Microsoft access.

There are lots of advantages of client server databases.

1)Single program reading and writing data the less chance of accidental changes or crashes of data.
2)Only single program play good role of security so enforcement of security is easy.
3)Client server databases use network bandwidth more efficiently then file server databases.
4)All things are handling by single computes so performance is good and quite impressive.
5)Client-servers databases use some good features that protect our data just like logging transactions and recovery from disk and network errors.

Some of these features are also available in file server approach but these need more expensive client server market. You can also learn more on dot net interview questions.

Adam Sturo has sinced written about articles on various topics from Family Travel, Architecture and Interview Questions. Know more about and. Adam Sturo's top article generates over 49500 views. to your Favourites.
EditorialToday Human Resource Career has 3 sub sections. Such as Recruitment Guide, Guide to Career and Human Resource Guide. With over 20,000 authors and writers, we are a well known online resource and editorial services site in United Kingdom, Canada & America . Here, we cover all the major topics from self help guide to A Guide to Business, Guide to Finance, Ideas for Marketing, Legal Guide, Lettre De Motivation, Guide to Insurance, Guide to Health, Guide to Medical, Military Service, Guide to Women, Pet Guide, Politics and Policy , Guide to Technology, The Travel Guide, Information on Cars, Entertainment Guide, Family Guide to, Hobbies and Interests, Quality Home Improvement, Arts & Humanities and many more.
About Editorial Today | Contact Us | Terms of Use | Submit an Article | Our Authors