DAM401 : ORACLE APPLICATION (2014)

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

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