Sql Server Interview Questions on File Server and Client Server Database

Two of the main things, the data of this approach is working. The work of these two different ways.

The approach of the database file server, data stored in a file, users need to get data directly from a file. Directly changed when the file is open is made on the application. Data files and writes these files. If the user data 10 and 10 who have been working to write the file.

In the client-server approach is still the data is stored in a file, but from a server, all servers in the access control hand. When to apply for any would like to use existing data, and then use the application send a request to the server. To read later, the server requests and send feedback. When to apply for any you want to write the request in the file sent to the server on the server, something written on the document. A person from the read and write data files.

Oracle, Informix, Microsoft SQL Server are the best suit for example, client-server databases. Single-user desktop, such as Microsoft Access.

There are lots of advantages of client server databases.

Changes or accidental crash data) less chance of data read and write a single program.
2) Only single program play good role of security so enforcement of security is easy.
3) and more efficient client-server databases, database files using the server's network bandwidth.
4) All things are handling by single computes so performance is good and quite impressive.
5) The client-server database on the use of some good features, like a record transactions and to protect the disk and network errors, restore our data.

Some of these features also in the file server approach can be used, you need these more expensive client-server market. Also, you can learn a dot net interview questions for many.