ALLInterview.com :: Home Page KalAajKal.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  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
what is trigger?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is trigger?
Answer
# 1
Trigger is just like a storedprocedure but the only 
difference is it is automatically call when the event ocour
or fire.
 
Is This Answer Correct ?    0 Yes 0 No
Naresh
 
  Re: what is trigger?
Answer
# 2
Trigger is procedure which is automatically fires when we 
modify the data in table(After i.e.,Data Manipulation wiil 
be one)
 
Is This Answer Correct ?    1 Yes 0 No
Shanthi Bhushan
 
 
 
  Re: what is trigger?
Answer
# 3
A trigger is a DB object like proc. or func. stored in data 
dictonary. It will fire implicitly with event on which it 
written.

Main use of a trigger are

-- we can take backup of data.
-- Can be used for auditing purpose. 
-- For applying complex bussiness rule.
   Etc.
 
Is This Answer Correct ?    0 Yes 0 No
Roopesh Kumar
 
  Re: what is trigger?
Answer
# 4
Triggers are simply stored procedures that are executed 
automatically by the database whenever
some event (usually a table update) happens.

sample:

CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be 
displayed ’  :NEW.NAME);
END;
 
Is This Answer Correct ?    1 Yes 0 No
Srividhya.s
 
  Re: what is trigger?
Answer
# 5
Trigger is a special kind of stored procedure executed 
certain event occurs.
 
Is This Answer Correct ?    0 Yes 0 No
Srini
 
  Re: what is trigger?
Answer
# 6
trigger is used nto change the control from one state to 
another
 
Is This Answer Correct ?    0 Yes 0 No
Aarthi
 
  Re: what is trigger?
Answer
# 7
trigger is stored procedure it execute the one event
when another event is happenning for example it can do the 
insert operation as well as select operation.
 
Is This Answer Correct ?    0 Yes 0 No
Sudha
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
What are the steps in connecting to database ? Microsoft1
What provider ADO.net use by default ? Accenture3
How to get oledb connection?  3
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?  5
I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?  2
ADO and ADO.NET differences ? Microsoft2
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception. Fulcrum-Logic2
When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors? HCL4
What are the three Ado objects? Microsoft5
Explain different methods and Properties of DataReader which you have used in your project?  2
What is a datatable? SBI3
How would u connect to database using .NET? TCS2
What are the attirbutes of DataSet? IBM4
what is meant by connection pooling and event pumbling in ado.net TCS2
What providers does ado.net uses internally ? Digital-GlobalSoft1
what is data access layer? Honeywell2
what is the syntax code for oldb to connect oracle?  1
what is a dataview?why is it used for? Choice-Solutions3
How do you merge two datasets into the third dataset in a simple manner? IBM1
On ODP.net ? MMTS1
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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