Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application BC0050 Oracle

August 2009
Bachelor of Computer Application (BCA) – Semester 4
BC0050 – Oracle & Distributed Databases – four Credits
(Book ID: B0894)
Assignment Set – one (40 Marks)


ans all ques.

1. Write about the subsequent in the situation of Oracle Instance
• Memory components of SGA [10 Marks]
• Automatic Shared Memory Management
• Background processes
• Program Global Area


2. discuss the WHILE Loop statement and FOR loop statement in PL/SQL
[10 Marks]

3. Write about the subsequent Oracle 9i objects: [10 Marks]
• Logical Storage Structures
• Database Blocks
• Physical Storage Structures

4. Write about the Design of Database Fragmentation [10 Marks]


August 2009
Bachelor of Computer Application (BCA) – Semester 4
BC0050 – Oracle & Distributed Databases – four Credits
(Book ID: B0894)
Assignment Set – two (40 Marks)


ans all ques.

1. define the Oracle Architecture with a neat tagged diagram; Also discuss the individual components of the Architecture. [10 Marks]
2. define the following: [10 Marks]
• Distributed Data Base Management Systems
• Guidelines fro creating users
• PL / SQL Block Structures
• Centralized databases
3. provide the syntax of a function in PL/SQL. Write a function to sort the provided employee numbers in decreasing order. [10 Marks]


4. elaborate the uses of distributed databases ?.
[10 Marks]

Earning:   Approval pending.