Question 2 a) Outline how the Autonumber facility in Microsoft Access can be implemented in an Oracle database. Set out the objects that need to be created to implement such a solution and show the code for all aspects of the implementation. (40 marks) b) What is PL/SQL? Describe how PL/SQL can be used in a database and in application development and outline the benefits of using it. (20 marks) c) Explain locking and outline the types of locks available in DBMS today. (20 marks) d) Explain the role of the DATA_DICTIONARY in an Oracle database and give examples of its use and content. (20 marks)