DAM401 – Oracle Application

 

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

Leave a Reply

MEET OVER 2000 NOUN STUDENTS HERE. 

Join us for latest NOUN UPDATES and Free TMA answers posted by students on our Telegram. 

OUR ONLINE TUTORIAL CLASS IS NOW ON!!! JOIN US NOW. 
JOIN NOW!
close-link