NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
SEPTEMBER 2020 EXAMINATION

DAM401: ORACLE APPLICATIONS

Credit: 2 units

TIME ALLOWED: 2 Hours

INSTRUCTION: Answer Question 1 and any other THREE (3) Questions

1a. Briefly describe the following.

i. Primary key: (3 marks)

ii. Foreign key: (2 mark)

1bi. briefly explain the physical structures of a database. (5 marks)

1bii. Define log buffer. (1 mark)

1c. Outline the commonly used triggering events and the examples of numerous uses of triggers. (10 marks)

1d. briefly summarise the modes of locking in a multiuser database. (4 marks)

2a. Briefly describe the concept of data dictionary. (4 marks)

2b. Briefly explain data lock conversion versus lock escalation. (7 marks)

2c. The Optimal Flexible Architecture (OFA) is not perfect and provides the basis for good performance and easier administration. State the basis. (4 marks)

3a. Briefly describe the concept of schema object. (5 marks)

3b. Object Relational Database Management System (ORDBMS) is characterized by a number of additional features. Explain these features. (10 marks)

4a. Based on what you have learnt from this course, what strategy would you adopt in resolving an issue of “lock contention” in the event of an emergency? (4 marks)

4b. Enumerate and describe the key components of a package in Oracle database (7 marks)

4c. Outline the phases involved in the implementation of an SQL statement (4 marks)

5a. Explain transaction isolation levels. (12 marks)

5b. Identify three options for opening screen of Database Configuration Assistant (DBCA). (3 marks)