DAM401 : Oracle Application (2017)

NATIONAL OPEN UNIVERSITY OF NIGERIA,

University Village, Plot 91, Cadastral Zone, NnamdiAzikiwe Express Way, Jabi, Abuja

FACULTY OF SCIENCES

DEPARTMENT OF COMPUTER SCIENCE

JULY 2017 EXAMINATION

Course code: DAM 401
Course Title: Oracle Application
Time: 2 Hours
Instruction: Answer any Four (4) questions.
 
1a.       Define constraints state, list and define four (4) constraints supported by Oracle.[71/2marks]
1b.       Differentiate between Cell and Table.                                                                        [10 marks]
 
2a.       Highlight the five (5) steps that must be followed in the correct order when creating a Database   in Linux Operating system.                                                                                           [71/2 marks]
2b.       Discuss trigger and list the six (6) more commonly used triggering events.   [10 marks]
 
3a        Describe the causes of Lock Contention.                                                                   [71/2 marks]
3b        Write short note on Deadlocks and how can it be detected.                                      [10 marks]
 
4a.       Discuss the three sets of data dictionary views of Oracle.                                         [71/2 marks]
4b.       Highlight any five (5) categories of failures.                                                              [10 marks]
 
5a.       Discuss any five responsibilities of a Database Administrator.                                  [10 marks]
5b.       Discuss (SQL) Structured Query Language and the languages that made up of SQL.[71/2 marks]
 
6a        Explain the Database blocks.                                                                                      [10 marks]
6b.       Differentiate between Row and Column.                                                                  [71/2 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