Question 1. Give the structure of PL/SQL Blocks and explain
Question 2. Differentiate between PL/SQL functions and procedures
Question 3. Explain the following
- Parameter file
- Archive files
Question 4. Write about enterprise manager
Question 5. Explain the properties of Transaction?
Question 6. Write a small note on RMAN repository
Question 7. Write a cursor to open an employee database and fetch the employee record whose age is greater than 55
Question 8. Write a P/L SQL code to update employee table by calculating bonus for the sales target between
- 80 to 100-50%
- 60 to 80 -40%
- 40 to 60-30%
- <40-25%
Using case statement