Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application BC0050- Oracle & Distributed Databases - Assignment s for fall session - Question
Sunday, 09 June 2013 04:35Web
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. |