Difference between trigger and stored procedure.

Difference between trigger and stored procedure.

* A stored procedure can accept parameters while a trigger cannot.
* A trigger can’t return any value while stored procedures can.
* A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
* Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
* A trigger cannot be written in a stored procedure. However, the reverse is not possible.



Explain Row level and statement level trigger.

Row-level: - They get fired once for each row in a table affected by the statements.
Statement: - They get fired once for each triggering statement.

1. What is an oracle instance?
   2. What is a view?
   3. What is referential integrity?
   4. Name the data dictionary that stores user-defined constraints?
   5. What is a collection of privileges?
   6. What is a snapshot?
   7. What is a synonym?
   8. What is a cursor?
   9. What is a sequence?
  10. What is a trigger?
  11. What is an exception?
  12. What is a partition of table?
  13. What are pseudo-columns in SQL? Provide examples.
  14. What are the Data Control statements?
  15. What is a schema?
  16. What is a type?
  17. What is a data model?
  18. What is a relation?
  19. Advantages of redo log files?
  20. What is an Archiver?
  21. What is a database buffer cache?
  22. What are the background processes in Oracle?
  23. %type and %rowtype are attributes for…?
  24. What are the steps in a two-phase commit?
  25. What is a union, intersect, minus?
  26. What is a join, explain the types of joins?
  27. What is a co-related sub-query?
  28. ODBC stands for…?
  29. Data-type used to work with integers is?
  30. Describe data models?
  31. Describe the Normalization principles?
  32. What are the types of Normalization?
  33. What is de-normalization?