Exam Details

Subject Database Management Systems
Paper
Exam / Course Post Graduate Diploma in Computer Application (PGDCA)/ Advance Diploma inComputer Applications (ADCA) / Masters in Computer Applications (MCA)
Department School of Computer and Information Sciences (SOCIS)
Organization indira gandhi national open university
Position
Exam Date December, 2015
City, State new delhi,


Question Paper

With the help of a neat diagram, explain the physical DBMS architecture.

With the help of an appropriate example for each, explain the following basic set operations:

UNION

INTERJECTION

SET DIFFERENCE

CARTESIAN PRODUCT

Design an ER diagram for the specifications to maintain any IGNOU's study centre. Clearly indicate the entities, attributes, constraints, relationships and the cardinality.

Differentiate between Horizontal fragmentation and Vertical fragmentation with the help of suitable examples in Data fragmentation of Distributed databases.

Explain the Sequential file organization. Give the advantages and disadvantages of it.

Write in detail about B-Tree structure for indexes with a neat diagram.

Explain "Write Ahead Log Protocol" with suitable example/diagram.

Explain in detail the mechanism of Optimistic Concurrency Control to prevent concurrency related problems, with the help of an example.

Consider the following Relations:

Employee (EName, EId, Addrl, Addr2, City, State)

Works Branch, Dept_Name, Dept_No, Dept_Head)

Write the SQL statements for the following:

Find all the ENames of employees who work in FINANCE department of Delhi Branch.

Find the Dept_Head for the employee if EName and EId are given.

With the help of an example for each, explain Host Updates, Dirty Reads and Unrepeatable Reads of Concurrent transactions.

Give the difference between operating system and database security.

Explain the different forms of Authorization techniques.

5. Write short notes on the following:

Any 4 Commands of DML

Serialisable Schedules

Data Replication in Distributed Databases

3-Tier Architecture


Departments

  • Centre for Corporate Education, Training & Consultancy (CCETC)
  • Centre for Corporate Education, Training & Consultancy (CCETC)
  • National Centre for Disability Studies (NCDS)
  • School of Agriculture (SOA)
  • School of Computer and Information Sciences (SOCIS)
  • School of Continuing Education (SOCE)
  • School of Education (SOE)
  • School of Engineering & Technology (SOET)
  • School of Extension and Development Studies (SOEDS)
  • School of Foreign Languages (SOFL)
  • School of Gender Development Studies(SOGDS)
  • School of Health Science (SOHS)
  • School of Humanities (SOH)
  • School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
  • School of Journalism and New Media Studies (SOJNMS)
  • School of Law (SOL)
  • School of Management Studies (SOMS)
  • School of Performing Arts and Visual Arts (SOPVA)
  • School of Performing Arts and Visual Arts(SOPVA)
  • School of Sciences (SOS)
  • School of Social Sciences (SOSS)
  • School of Social Work (SOSW)
  • School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
  • School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
  • School of Translation Studies and Training (SOTST)
  • School of Vocational Education and Training (SOVET)
  • Staff Training & Research in Distance Education (STRIDE)

Subjects

  • Accounting and Financial Management
  • Advanced Database Design
  • Advanced Discrete Mathematics
  • Advanced Internet Technologies
  • Artificial Intelligence and Knowledge Management
  • Communication Skills
  • Computer Graphics and Multimedia
  • Computer Organisation & Assembly Language Programming
  • Data and File Structure
  • Data Communication and Computer Networks
  • Database Management System
  • Database Management Systems
  • Design and Analysis of Algorithm
  • Discrete Mathematics
  • Elements of Systems Analysis & Design
  • Numerical and Statistical Computing
  • Object Oriented Analysis and Design
  • Object Oriented Technologies and Java Programming
  • Operating System Concepts and Networking Management
  • Operating Systems
  • Parallel Computing
  • Principles of Management and Information Systems
  • Problem Solving and Programming
  • Software Engineering
  • Systems Analysis and Design