What is cursor ? And what is difference between Trigger ?

Answers were Sorted based on User's Feedback



What is cursor ? And what is difference between Trigger ?..

Answer / bhaskar

Cursor is an Database object and retrive the rows from
database row by row ,
And it is maily use for ot reduce the network traffic
it contains 5 features
1.DECLARE the Cursor
2.OPEN the cusrsor
3.FETCH the cursor
4.CLOSE the cursor
5.DEALLOCATE the cursor

TRIGGER : IT is also an database object and You can
perform an anction Trigger will fire automatacallly.
like (DML,DDL)
They can cascade changes through related tables in the
database; however, these changes can be executed more
efficiently using cascading referential integrity
constraints.

They can guard against malicious or incorrect INSERT,
UPDATE, and DELETE operations and enforce other
restrictions that are more complex than those defined with
CHECK constraints.

Multiple DML triggers of the same type (INSERT, UPDATE, or
DELETE) on a table allow multiple, different actions to
take place in response to the same modification statement.

Is This Answer Correct ?    53 Yes 10 No

What is cursor ? And what is difference between Trigger ?..

Answer / sanjay kumar dinda

Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis, instead of
the typical SQL commands that operate on all the rows in
the set at one time.


Trigger is a database object invoked automatically when any
event occured.
These aevents are
Delete, Insert, Update etc....

SQL server store the intermediate data into to dummy table
INSERTED and DELETED...

At the time of insert operation SQL Server STores inserted
rows into the INSERTED table and at the time of delete or
update SQL Server stores the information into DELETED dummy
table

Is This Answer Correct ?    19 Yes 7 No

What is cursor ? And what is difference between Trigger ?..

Answer / adisha

CURSOR:
1.They are temporary work areas.
2.They are not stored independently in the database.
3.We can create cursor both implicitly and explicitly.
4.Cursors can take parameters.
5.They are used to process the result of query.

TRIGGER:
1.They are named PL SQL blocks.
2. They are stored in database.
3. They can be invoked automatically.
4. They cannot take parameters.
5. They are used to enforce data in dignity rules.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is msdb database? : SQL Server Architecture

0 Answers  


How can I create a new template for import ? : sql server management studio

0 Answers  


Plz tell about backup&recovery?

3 Answers  


Define left outer join?

0 Answers  


Scalability, Availability, Integration with internet, etc.)?

0 Answers  






How to assign new column names in a view?

0 Answers  


What are the types of joins in sql?

0 Answers  


What are sp_configure commands and set commands?

0 Answers  


What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


What is the use of keyword with encryption.

0 Answers  


Explain forward - only cursors?

0 Answers  


What are a scheduled jobs or what is a scheduled tasks?

0 Answers  


Categories