Networking Interview Questions and Answers
Question - 31 : - What are TP-Lite and TP-Heavy Monitors?
Answer - 31 : - 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.
Question - 32 : - What are the two types of OLTP?
Answer - 32 : - TP lite, based on stored procedures. TP heavy, based on the TP monitors.
Question - 33 : - What is a TP Monitor?
Answer - 33 : - There is no commonly accepted definition for a TP monitor. According to Jeri Edwards' a TP Monitor is "an OS for transaction processing".
Question - 34 : - What are Super servers?
Answer - 34 : - These are fully-loaded machines which includes multiprocessors, high-speed disk arrays for intervive I/O and fault tolerant features.
Question - 35 : - TP Monitor does mainly two things extremely well. They are Process management and Transaction management.?
Answer - 35 : - They were originally introduced to run classes of applications that could service hundreds and sometimes thousands of clients. TP Monitors provide an OS - on top of existing OS - that connects in real time these thousands of humans with a pool of shared server processes.
Question - 36 : - What is meant by Asymmetrical protocols?
Answer - 36 : - There is a many-to-one relationship between clients and server. Clients always initiate the dialog by requesting a service. Servers are passively awaiting for requests from clients.
Question - 37 : - What are the types of Transparencies?
Answer - 37 : - The types of transparencies the NOS middleware is expected to provide are:-
Location transparency
Namespace transparency
Logon transparency
Replication transparency
Local/Remote access transparency
Distributed time transparency
Failure transparency and
Administration transparency.
Question - 38 : - What is the difference between trigger and rule?
Answer - 38 : - The triggers are called implicitly by database generated events, while stored procedures are called explicitly by client applications.
Question - 39 : - What are called Transactions?
Answer - 39 : - The grouped SQL statements are called Transactions (or) A transaction is a collection of actions embused with ACID properties.
Question - 40 : - What are the building blocks of Client/Server?
Answer - 40 : - The client
The server and
Middleware.