Question 1:
Make a distinction between PL/SQL functions and procedures.
Question 2:
Sketch the diagram of logical structure of oracle database and describe it in brief.
Question 3:
Discuss and critically illustrate out the objectives of Query Processing.
Question 4:
Illustrate out the steps which are involved in recovery of distributed transactions.
Question 5:
Create a PL/SQL program to insert data in student table and exhibit the details of student having Reg.No 1010.
Question 6:
Make a PL/SQL program to make first ten natural numbers using loop, while and for.