Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2008 M.C.A Computer S.M.UAssignment s . -paper17

ASSIGNMENTS – AUGUST 2008

Subject Code: MC0021
Subject Name: Oracle9i & Distributed Databases
Course Name: MCA Old
Semester: IV Credits: 4
Marks: 40


[Book ID: B0894] Answer all ques.

1. define the following: [10 Marks]
• Users and Schemas
• Guidelines fro creating users
• PL / SQL Block Structures
• Looping statements in PL/SQL


2. Write a database trigger to implement the subsequent check condition:
• Given the subsequent table: [10 Marks]
Empno Empname Joining Date


Every time the user enters the employee number in the above table, it should check that it is always >1 and <200.

3. define the Oracle Architecture with a neat tagged diagram; Also discuss the individual components of the Architecture. [10 Marks]

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






Subject Code: MC0021
Subject Name: Oracle9i & Distributed Databases
Course Name: MCA Old
Semester: IV Credits: 4
Marks: 40


[Book ID: B0894] Answer all ques.

1. discuss about the different iterative control statements in PL / SQL with the help of suitable examples for every. [10 Marks]

2. 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

3. explain the subsequent kinds of Data Fragmentation Mechanisms:
• Horizontal Data Fragmentation [10 Marks]
• Derived Horizontal Fragmentation
• Vertical Fragmentation
• Mixed Fragmentation

4. explain the subsequent with respect to developing Distributed Database Applications: [10 Marks]
• Distributed Query Optimization
• Remote and Distributed SQL Statements
• Remote Procedure Calls (RPCs)
• Remote and Distributed Transactions

Earning:   Approval pending.