Decimal Technologies SQL Developer Interview Questions and Answers

Functions return a value while stored procedures do not. Functions can be used in SELECT statements, stored procedures cannot.

• Functions return a value, stored procedures do not

• Functions can be used in SELECT statements, stored procedures cannot

• Functions must return a value, stored procedures may or may not

Use a self join to find the manager of the employee.

• Join the employee table with itself on the manager_id and employee_id columns

• Select the manager's details based on the employee's manager_id

A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.

• Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.

• Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

• Triggers can be defined to execute before or after the triggering event.