Computer Networking Interview Questions And Answers

21. What are all the Base services provided by the OS?
Task preemptionTask prioritySemaphoresInterprocess communications (IPC)Local/Remote Interprocess communicationThreadsIntertask protectionMultiuserHigh performance file systemEfficient memory management andDynamically linked Run-time extensions.
22. What are the roles of SQL?
SQL is an interactive query language for ad hoc database queries.SQL is a database programming language.SQL is a data definition and data administration language.SQL is the language of networked database serversSQL helps protect the data in a multi-user networked environment.Because of these multifacted roles it plays, physicists might call SQL as "The grand unified theory of database".
23. What is Structured Query Langauge (SQL)?
SQL is a powerful set-oriented language which was developed by IBM research for the databases that adhere to the relational model. It consists of a short list of powerful, yet highly flexible, commands that can be used to manipulate information collected in tables. Through SQL, we can manipulate and control sets of records at a time.
24. What are the characteristics of Client/Server?
ServiceShared resourcesAsymmentrical protocolsTransparency of locationMix-and-matchMessage based exchangesEncapsulation of servicesScalabilityIntegrity Client/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.
25. What is Remote Procedure Call (RPC)?
RPC hides the intricacies of the network by using the ordinary procedure call mechanism familiar to every programmer. A client process calls a function on a remote server and suspends itself until it gets back the results. Parameters are passed like in any ordinary procedure. The RPC, like an ordinary procedure, is synchoronous. The process that issues the call waits until it gets the results. Under the covers, the RPC run-time software collects values for the parameters, forms a message, and sends it to the remote server. The server receives the request, unpack the parameters, calls the procedures, and sends the reply back to the client. It is a telephone-like metaphor.
26.What are the main components of Transaction-based Systems?
Resource ManagerTransaction Manager andApplication Program.
27. What are the three types of SQL database server architecture?
Process-per-client Architecture. (Example: Oracle 6, Informix )Multithreaded Architecture. (Example: Sybase, SQL server)Hybrid Architecture (Example: Oracle 7)