Home > Download > SMU - Question Paper
> BCA > BC0050
Oracle & Distributed Databases
This is the collection of
Sikkim Manipal University (SMU) question and answers for Oracle & Distributed Databases. It will help
to prepare your examination. All question paper are
classified as per semester, subject code and question type of Part A, Part B and Part C with
multiple
choice options
as same as actual examination. SMU question papers includes
year 2024, 2023, 2022 Sem I, II, III, IV, V, VI examinations
of all subjects.
SMU question test set of old,
last and previous year are updated
regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net,
Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested
you kindly send me the question paper of Oracle & Distributed Databases, SMU - Bachelor of Computer Application.
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
Home > Download > SMU - Question Paper
> BCA > BC0050