-
What is OLTP?
In the transaction server, the client component usually includes GUI and the server components usually consists of SQL transactions against a database. These applications are called OLTP (Online Transaction Processing)OLTP Applications typically,Receive a fixed set of inputs from remote clients.Perform multiple pre-compiled SQL comments against a local database.Commit the work andReturn a fixed set...
-
What is a TP Monitor?
There is no commonly accepted definition for a TP monitor. According to Jeri Edwards' a TP Monitor is "an OS for transaction processing".TP Monitor does mainly two things extremely well. They areProcess management and Transaction managementThey were originally introduced to run classes of applications that could service hundreds and sometimes thousands of clients. TP Monitors provide an OS - on top...
-
What are the main components of Transaction-based Systems?
Resource ManagerTransaction Manager andApplication Program
-
-
What are TP-Lite and TP-Heavy Monitors?
TP-Lite is simply the integration of TP Monitor functions in the database engines.TP-Heavy are TP Monitors which supports the Client/Server architecture and allow PC to initiate some very complex multiserver transaction from the desktop.
-
What are the five major technologies that can be used to create Client/Server applications?
Database ServersTP MonitorsGroupwareDistributed ObjectsIntranets.
-
-
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 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 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 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 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 are the two broad classes of middleware?
General middlewareService-specific middleware
-
What is meant by Middleware?
Middleware is a distributed software needed to support interaction between clients and servers. In short, it is the software that is in the middle of the Client/Server systems and it acts as a bridge between the clients and servers. It starts with the API set on the client side that is used to invoke a service and it covers the transmission of the request over the network and the resulting response.It...
-
What is meant by Transparency?
Transparency really means hiding the network and its servers from the users and even the application programmers.
-
Client Server Interview Questions
Ans