Set - 1

Question 16 :

What is the difference between trigger and rule?

Answer :

The triggers are called implicitly by database generated events, while stored procedures are called explicitly by client applications.


Question 17 :

What are called Transactions?

Answer :

The grouped SQL statements are called Transactions (or) A transaction is a collection of actions embossed with ACID properties.


Question 18 :

What are the building blocks of Client/Server?

Answer :

The client
The server and
Middleware.


Question 19 :

Explain the building blocks of Client/Server?

Answer :

The client side building block runs the client side of the application.
The server side building block runs the server side of the application.


Question 20 :

The middleware building block runs on both the client and server sides of an application. It is broken into three categories:-

Answer :

Transport stack
Network OS
Service-specific middleware.