Sql Server Interview Questions on File Server and Client Server Database
Description:
This article provides you the informations on sql server interview questions on file server and client server database.
Content:
One of major things in two of this approach is of working with data but both of these works in different manner.
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.
Author: Adam Sturo
About Author:
Know more about sql server interview questions and sql server 2000 query
Random related phrase:
poor credit small business loan
Misspelled random related phrase:
ppoor credit small business loan, oor credit small business loan, pooor credit small business loan, por credit small business loan, pooor credit small business loan, por credit small business loan, poorr credit small business loan, poo credit small business loan, poor credit small business loan, poorcredit small business loan, poor ccredit small business loan, poor redit small business loan, poor crredit small business loan, poor cedit small business loan, poor creedit small business loan, poor crdit small business loan, poor creddit small business loan, poor creit small business loan, poor crediit small business loan, poor credt small business loan, poor creditt small business loan, poor credi small business loan, poor credit small business loan, poor creditsmall business loan, poor credit ssmall business loan, poor credit mall business loan, poor credit smmall business loan, poor credit sall business loan, poor credit smaall business loan, poor credit smll business loan, poor credit smalll business loan, poor credit smal business loan, poor credit smalll business loan, poor credit smal business loan, poor credit small business loan, poor credit smallbusiness loan, poor credit small bbusiness loan, poor credit small usiness loan, poor credit small buusiness loan, poor credit small bsiness loan, poor credit small bussiness loan, poor credit small buiness loan, poor credit small busiiness loan, poor credit small busness loan, poor credit small businness loan, poor credit small busiess loan, poor credit small busineess loan, poor credit small businss loan, poor credit small businesss loan, poor credit small busines loan, poor credit small businesss loan, poor credit small busines loan, poor credit small business loan, poor credit small businessloan, poor credit small business lloan, poor credit small business oan, poor credit small business looan, poor credit small business lan, poor credit small business loaan, poor credit small business lon, poor credit small business loann, poor credit small business loa
No comments:
Post a Comment