-
What are the characteristics of Client/Server?
ServiceShared resourcesAsymmentrical protocolsTransparency of locationMix-and-matchMessage based exchangesEncapsulation of servicesScalabilityIntegrityClient/Server computing is the ultimate "Open platform". It gives the freedom to mix-and-match components of almost any level. Clients and servers are loosely coupled systems that interact through a message-passing mechanism.
-
-
What is meant by Asymmetric Multiprocessing (AMP)?
It imposses hierarchy and a division of labour among processors. Only one designated processor, the master, controls (in a tightly coupled arrangement) slave processors dedicated to specific functions.
-
-
What is ACID property?
ACID is a term coined by Andrew Reuter in 1983, which stands for Atomicity, Consistence, Isolation and Durability.
-
What is meant by Horizontal scaling and Vertical scaling?
Horizontal scaling means adding or removing client workstations with only a slight performance impact.Vertical scaling means migrating to a larger and faster server machine or multiservers.
-
What are Stored procedures?
A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection...
-
What are the five major technologies that can be used to create Client/Server applications?
Database ServersTP MonitorsGroupwareDistributed ObjectsIntranets.
Client Server Interview Questions
Ans