Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started