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