Exam Details

Subject Distributed Database
Paper
Exam / Course Diploma -VIEP-Computer Science and Engineering(DCSVI)/Advanced Level O Certificate Course In Cse (ACCSVI) B.Tech. Computer Science And Engineering (BT
Department School of Engineering & Technology (SOET)
Organization indira gandhi national open university
Position
Exam Date June, 2015
City, State new delhi,


Question Paper

Compare federated database systems with client/server systems.

Explain the notions of transparency and autonomy.

Define ACID properties of transaction.

Explain conflict and view serializabilty with the help of an example.

3. Define concurrency. Explain the different methods for concurrency control in distributed transaction.

Explain multi-way join and semi-joins with the help of suitable examples.

Explain the difference between file server and client server architecture.

5. Discuss how query optimization is useful In distributed database.

6. Explain the lock base protocol in detail. What is the role of time stamp based protocol in locking?

Define scheduler. Why is its activity important for concurrency control

Explain different Database Recovery Problems.

8. Describe the buffer architecture and buffer management schemes.

9. What do you understand by fragmentation Explain the different methods for fragmentation.

10. Write short notes on any two of the following:

2 PL

OLAP Data Model

Multi-database Systems


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

  • Advanced ComputerArchitecture
  • Algorithms and Logic Design
  • Artificial Intelligence
  • Basics of Networking
  • Bio-Informatics
  • C Programming
  • Computer Architecture
  • Computer Networks
  • Computer Organisations
  • Computer Organization
  • Cryptography And Network Security
  • Data Modelling And Uml
  • Data Structures
  • Data Warehousing And Mining
  • Database Management System
  • Design And Analysis Of Algorithm
  • Digital Image Processing
  • Discrete Maths Structure
  • Distributed Database
  • E-Business
  • Elective-Computer Networks
  • Embedded System
  • Formal Languages And Automata
  • Fuzzy Systems
  • Java Basic and Object Modeling Design
  • Logic Design
  • Microprocessor
  • Mobile Computing
  • Neural Network
  • Numerical Methods and Computation
  • Object Modeling And Design
  • Object Oriented Design And Programming
  • Object Oriented Programming
  • Operating System
  • Operating Systems
  • Parallel Algorithms
  • Pattern Recognition
  • PC Assembly and Maintenance
  • Principles of Communication Engineering
  • Principles Of Programming Languages
  • Real Time Systems
  • Software Engineering
  • Software Project Management (Spm)
  • Software Quality Engineering
  • Software Reusability
  • System Analysis and Design
  • System Programming And Compiler Design
  • Theory Of Computation
  • Unix Internals And Shell Programming
  • Visual Basic Programming
  • Web Technology