ALLInterview.com :: Home Page Forum9.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories >> Software >> Client-Server >> Client-Server-General
 
 


 

 
 Client Server Architecture interview questions  Client Server Architecture Interview Questions
 Client Server General interview questions  Client Server General Interview Questions
Question
What are Triggers and Rules?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are Triggers and Rules?
Answer
# 1
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 
STATEMENT EXECUTED.
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:
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.
 
are you clear if you want any clarification please mail to 
me.
 
4
Rajendra Prasad Reddy Penumall
 
 
 
 
Other Client Server General Interview Questions
 
  Question Asked @ Answers
 
What is an "Intranet"?  1
What are the three types of SQL database server architecture? CSC1
What is a Server process?  1
What is Load balancing?  1
What is ACID property?  1
What are Super servers?  2
What are the different types of servers?  2
what is Upsizing,down-sizing? Wipro3
What is a Two-Tier Architecture?  1
What are Triggers and Rules?  1
What is Groupware server? Wipro1
What is meant by Horizontal scaling and Vertical scaling? Microsoft1
What is Remote Data Management?  1
What is Client-server Computing?  1
What are called Non-GUI clients, GUI Clients and OOUI Clients? Wipro1
What are called Fat clients and Fat servers? Cisco1
What are the building blocks of Client Server?  2
What is Cooperative Processing?  1
What are the characteristics of client/server architecture?  2
What are the benefits obtained by using the Client Server oriented TP Monitors Client Server applications? CSC2
 
For more Client Server General Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com