Question 1 Differentiate between PL/SQL functions and procedures
Question 2 Draw the diagram of logical structure of oracle database and explain it in brief
Question 3 Discuss the objectives of Query Processing
Question 4 Explain the steps involved in recovery of distributed transactions
Question 5 Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010
Question 6 Create a PL/SQL program to generate first 10 natural numbers using loop, while and for