NATIONAL OPEN UNIVERSITY OF NIGERIA
14-16 AHMADU BELLO WAY, VICTORIA ISLAND LAGOS
SCHOOL OF SCIENCE AND TECHNOLOGY
MARCH/APRIL 2015 EXAMINATION
Course code: DAM401
Course Title: Oracle Application
Time: 2.5 Hours
Instruction: Answer any Four (4) questions.
1a. Differentiate between Cell and Table. [4 marks]
1b. Write short note on Function and Package. [6marks]
1c. List and define four (4) constraints supported by Oracle.[71/2marks]
2a. Discuss Database Triggers. [2.5 marks]
2b. List the six (6) more commonly used triggering events. [6 marks]
2c. Explain the three(3) sets of Oracle data dictionary views. [9 marks]
3a. Highlight the five (5) steps that must be followed in the correct order when creating a Database in Linux Operating system. [5 marks]
3b. State the five steps of creating database, following the correct order. [5 marks]
3c. Describe the causes of Lock Contention. [71/2 marks]
4a Explain what is meant by Deadlocks and how it can be detected. [5 marks]
4b. Write short note on Oracle Datafiles. [5 marks]
4c. Discuss the three(3) sets of data dictionary views of Oracle. [71/2 marks]
5a. Highlight any five (5) categories of failures. [5marks]
5b. Explain Database Blocks. [5 marks]
5c. Discuss languages that make up SQL. [71/2 marks]
6a. Differentiate between VARCHAR2 and CHAR data type. [4 marks]
6b. Explain oracle physical and logical storage. [8marks]
6c. Discuss (SQL) Structured Query Language. [5.5marks]
You can get the exam summary answers for this course from 08039407882
Check the sample below