NATIONAL OPEN UNIVERSITY OF NIGERIA
14/16 AHMADU BELLO WAY, VICTORIA ISLAND, LAGOS
SCHOOL OF SCIENCE AND TECHNOLOGY
MARCH/APRIL 2014 EXAMINATION
COURSE CODE: DAM401
COURSE TITLE: ORACLE APPLICATION
TIME ALLOWED: 21/2 HOURS
INSTRUCTION: ANSWER ANY FOUR QUESTIONS IN ALL
1a. Discuss the three sets of data dictionary views of Oracle. [71/2 marks]
1b. Differentiate between Cell and Table. [10 marks]
2a. Differentiate between Row and Column. [71/2 marks]
2b Write short note on Deadlocks and how can it be detected. [10 marks]
3a. Discuss (SQL) Structured Query Language and the languages that made up of SQL. [71/2 marks]
3b. Discuss trigger and list the six (6) more commonly used triggering events. [10 marks]
4a. Define constraints state, list and define four (4) constraints supported by Oracle. [71/2 marks]
4b. Highlight any five (5) categories of failures. [10 marks]
5a. Highlight the five (5) steps that must be followed in the correct order when creating a Database in Linux Operating system. [71/2 marks]
5b. Discuss any five responsibilities of a Database Administrator. [10 marks]
6a Describe the causes of Lock Contention. [71/2 marks]
6b Explain the Database blocks. [10 marks]
- For exam summary for any course contact 08039407882
Exam summary sample below
