Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 M.Sc Information Technology MT0046 –: Oracle9i - Assignment s for fall session - Question Paper

August 2009
Master of Science in info Technology (MScIT-NEW) – Semester 3
MT0046 –: Oracle9i– 4Credits

(Book ID: B0894)
Assignment Set – one (40 Marks)


[Book ID: B0894]

every ques. carries five marks

1. Mention the various modular database application programs in PL/SQL
2. Write the syntax of creating PL/SQL trigger
3. Differentiate ranging from shared pool and large pool of oracle memory component
4. How background processes are useful in oracle database? discuss
5. Explain the notions of transparency and site autonomy.
6. Describe the Oracle Architecture with a neat tagged diagram
7. Explain the individual components of the Architecture.
8. explain the features of the heterogeneous services

.













August 2009
Master of Science in info Technology (MScIT-NEW) – Semester 3
MT0046 –: Oracle9i– 4Credits
(Book ID: B0894)
Assignment Set – two (40 Marks)

[Book ID: B0894]

every ques. carries eight marks

1. List the objectives of Query processing
2. discuss the features of RMAN Repository
3. Discuss the relative advantages of centralized and distributed databases
4. What benefits does strict two-phase locking provide? What disadvantages result?
5. elaborate characteristics of distributed query processor? discuss

Earning:   Approval pending.