What are the disadvantages of the client/server model? »
| 0 Comments |
Heterogeneity of the system results in reduced reliablity. May not be suitable for all applications. Managing and tuning networks becomes difficult.
Category: CLIENT/SERVER interview questions
What are the advantages of client/server model? »
| 0 Comments |
Flexibility of the system, scalability, cost saving, centralised control and implementation of business rules, increase of developers productivity, portability, improved network and resource utilization.
What are the three components of a client server model? »
| 0 Comments |
A Client, A Server and A Network/Communication software.
Why is it better to use an integrity constraint to validate data in a table than to use a stored procedure? »
| 0 Comments |
Because an integrity constraint is automatically checked while data is inserted into
a table. A stored has to be specifically invoked.
Why are the integrity constraints preferred to database triggers? »
| 0 Comments |
Because it is easier to define an integrity constraint than a database trigger.
What is a transaction? »
| 0 Comments |
A transaction is a set of operations that begin when the first DML is issued and end
when a commit or rollback is issued. BEGIN COMMIT/ROLLBACK are the boundries of
a transaction.
What are the various uses of database triggers? »
| 0 Comments |
Database triggers can be used to enforce business rules, to maintain derived values
and perform value-based auditing.
What is an integrity constraint? »
| 0 Comments |
An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table.
