Welcome to www.programmer2programmer.net tips for SMU Question Paper for BC0050


 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2018 New Projects
 Project Synopsis Download
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 SQL Server
  Oracle and DBA

100% Tested
Ready Academic IT Projects


Free download of Sikkim Manipal University, SMU previous year, last year, sample question paper for  : [Oracle & Distributed Databases] BC0050. Find question and answer for Part-A 2 marks, Part-B 4 Marks and Part-C 8 marks. Free download of question paper of previous year test.   Oracle & Distributed Databases , BC0050 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact

   SMU >> BCA >> BC0050

   Oracle & Distributed Databases

This is the collection of Sikkim Manipal University (SMU) question paper for BCA - Oracle & Distributed Databases. It will help you to prepare your examination. All questions are classified as per question type like PART - A of 2 marks, PART - B of 4 marks and PART - C of 8 marks same as actual examination. SMU question paper set which includes year 2018, 2017, 2016 SMU question papers of Oracle & Distributed Databases are updated regularly and it is absolutely free to use. SMU Question paper includes multiple choice question and answer as same as real and original examination. It will help you to study and prepare for your final SMU examination.

Sikkim Manipal University
SMU Question Paper
Latest and Updated
FREE to Download
  1. BCA
  2. MCA
  3. BSc IT
  4. MSc IT
  5. MBA

   Get SMU Assignment   

Course Name
        BCA (Bachelor of Computer Application)

Subject Code      
BC0050 (Oracle & Distributed Databases)

Get Questions        PART - A    PART - B    PART - C

Oracle & Distributed Databases Syllabus.

Unit 1 - Oracle9i and PL/SQL
Introduction; Users of Oracle; Overview of PL/SQL; Fundamentals of PL/SQL; Iterative Control in PL/SQL

Unit 2 - PL/SQL Functions, Procedures and Packages
Introduction; PL/SQL Functions and Procedures; Database Triggers; Cursors ; Packages

Unit 3- Oracle Architecture
Introduction; The Oracle Database; Oracle Architecture; The Oracle Instance; The Physical Files of the Database; Starting and Stopping the Oracle Database; Executing SQL statement in Oracle; Oracle9i Products and Tools

Unit 4 - Oracle9i Database Objects
Introduction; Oracle9i Objects; Data Dictionary Overview; Oracle's Object-Oriented Features;

Unit 5 - Distributed Databases Overview
Introduction; Distributed Processing; Features of Distributed versus Centralized Databases; Uses of Distributed Databases; Distributed Database Management Systems (DDBMS); Reference Architecture for Distributed Databases; Types of Data Fragmentation; Integrity Constraints in Distributed Databases

Unit 6 - Distributed Database Design and Query Processing
Introduction; A Framework for Distributed Database Design; The Design of Database Fragmentation; The Allocation of Fragments; Query Processing Problem; Objectives of Query Processing; Characterization of Query Processors; Layers of Query Processing

Unit 7- Types of Distributed Databases
Introduction; Heterogeneous Distributed Databases; Developing Distributed Database Applications; Transparency in a Distributed Database System; Administering an Oracle Distributed Database System; Tools for Administering Oracle Distributed Databases; Federated Distributed DBMS

Unit 8- Distributed Transaction Management
Introduction; Frame work for transaction management; Atomicity of Distributed Transactions

Unit 9 - Distributed Database Concurrency Management
Introduction; Concurrency Control for Distributed Transactions; Concurrency Control Based on Total Ordering; Recovery Overhead in Transaction Processing; Read-Only Distributed Transactions

Unit 10- Distributed Database Backup and Recovery
Introduction; The Traditional Backup Process; What’s New in Backup and Recovery?; Recovery Manager Advanced Architecture and Concepts; RMAN Repository; RMAN Backups Concepts; Remote Backup Systems; RAID backup technology

  Get Questions        PART - A    PART - B    PART - C

 Click here to get more question paper of MCA, BCA, BSC IT, MSC IT, MBA of SMU

(C) Atanu Maity, 2006-2018