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

Your email address will not be published. Required fields are marked *