1. Give full information about infrared technology, like applications, advantages, disadvatages?

it is a wire less tech use to transfer data from 1 device to

advantage :
► wireless.
► chip.

disadvantage :
► only work for small distance( in feet. )
► can not penetrate wall.

applications :
► remote based systems.
► mobiles.

2. Explain what is Upsizing, down-sizing?

Down Sizing is nothing but The Process of mo
ving an application from a {main frame ) to cheaper
system, typically a (client-server) system.

3. Explain what is infrared technology?

infrared is a data transfer or taking the instruction
technology in minimum distance without wire

4. What is Remote Procedure Call?

Remote procedure call is used to mount remote clients to
the servers.

5. What are the benefits obtained by using the Client Server oriented TP Monitors Client Server applications?

much better and faster access.. provision of security too..
higher tasks can be done in parallel.

6. Tell me What is Load balancing?

load balancing is a process where you will check the load
of all the nodes connected to the network and than decide
where to execute & in which node you want to distribute the
process for execution so that balance of the whole system
is maintained.

7. Do you know What are Triggers and Rules?

these two are SQL concepts

TRigger is a special type of stored procedure that
automatically takes effect when the data in a specified
table is modified.
triggers invoked in response to an INSERT,UPDATE OR DELETE
TRIGGERS are used to handle some exceptional conditions
if u r moving data 40 MB into data base,But data base having
only 30 mB free space then the trigger fires automatically
and the entire transaction automativcally roll backs.

Rules are database objects used to enforce data integrity.
this object bound to column or userdefined data types.
to ensure that only valid values are allowed to insert in
to columns.

so trigger acts automatically nad rollbacks the transaction
when error is occured.

rule is used to enforce data integrity on a column or user
defined data type.

8. Tell me What are the three types of SQL database server architecture?

Process-per-client Architecture.
Multithreaded Architecture.
Hybrid Architecture.

9. Explain What are called Non-GUI clients, GUI Clients and OOUI Clients?

Non-GUI Client: These are applications, generate server
requests with a minimal amount of human interaction.

GUI Clients: These are applicatoins, where occassional
requests to the server result from a human interacting with
a GUI (Example: Windows 3.x, NT 3.5)

OOUI clients : These are applications, which are highly-
iconic, object-oriented user interface that provides
seamless access to information in very visual formats.
(Example: MAC OS, Windows 95, NT 4.0)

10. Do you know What are Super servers?

A super-server or sometimes called a service dispatcher is a
type of daemon run generally on Unix-like systems.

It starts other servers when needed, normally with access to
them checked by 'tcpd'. It uses no (or very little)
resources when in idle state. This can be ideal for
workstations used for local web development, client/server
development or low traffic daemons with occasional usage
such as ident and SSH.

There is a slight delay in connecting, thus when compared to
pre-spawn servers, a 'super-server' setup may not be all
that quick in reaction to connection attempts, especially
when under high load. Some servers, such as hpa-tftpd,
therefore takeover the socket and listen on it themselves
for some specified interval, anticipating more connections
to come.

Download Interview PDF