Set - 1

Question 6 :

What are Triggers and Rules?

Answer :

Triggers are special user defined actions usually in the form of stored procedures, that are automatically invoked by the server based on data related events. It can perform complex actions and can use the full power of procedural languages.
A rule is a special type of trigger that is used to perform simple checks on data.


Question 7 :

What is meant by Transparency?

Answer :

Transparency really means hiding the network and its servers from the users and even the application programmers.


Question 8 :

What are TP-Lite and TP-Heavy Monitors?

Answer :

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 multi-server transaction from the desktop.


Question 9 :

What are the two types of OLTP?

Answer :

TP lite, based on stored procedures. TP heavy, based on the TP monitors.


Question 10 :

What is a Web server?

Answer :

This new model of Client/Server consists of thin, portable, "universal" clients that talk to superfast servers. In the simple form, a web server returns documents when clients ask for them by name. The clients and server communicate using an RPC-like protocol called HTTP.