Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31657 Views
- HCL, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How can you stop stored procedures from recompiling?
Why do we use functions?
what is difference between NULL and ISNULL in SQL Server 2008?
Which are the new data types introduced in sql server 2008?
Where sql server usernames and passwords are stored in a sql server?
Explain about Normalization?
What is the size of transaction log file?
What is transact-sql ddl trigger?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are the types of indexing?
What is the difference between the 2 operating modes of database mirroring?
What is the difference between mysql and sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What do you mean by a Composite primary key?
What is a self join in sql server?
