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, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages: 3
IBICSE-007 1
B.Tech. -VIEP -COMPUTER SCIENCE AND
ENGINEERING (BTCSVI)
Term-End Examination
June, 2016
00866
BICSE-007 DISTRIBUTED DATABASE
Time hours Maximum Marks: 70
Note: Answer any seven questions. All questions carry equal marks.
1. Explain the general architecture of a parallel. database system and shared memory architecture. 10
2. Which process of DDBS design is used when we want to design DDBS from scratch Also draw and explain that process. 10
3. "Providing transparency is needed in DDBMS." Comment with suitable examples. 5
How does distributed transaction manager deal with multiple copies of data, when concurrency control is based on locking? 5
4. "Dynamic query optimization approach is best for Ad-hoc queries." -Write your comments on this statement by giving justification for your answer. 5
What is query optimization List the components of query optimizer software and explain anyone from that. 5
5. How can the correctness rules be applied to primary and derived horizontal fragmentation? 5
Define distributed deadlock detection. 5
6. Describe query decomposition and data localization in detail. 10
7. Explain ACID properties of transaction. 5
What are the lazy replication protocols? 5
8. Describe the fundamental approaches to construct a reliable system. 5
Explain the distributed cost model with an example. 5
9. Differentiate between federated database system and multi database system. 5
Explain three-phases commit protocol in detail. 5
10. Write short notes on any two of the following: 2x5=10
Scheduler
2PC
Fragmentation of database
IBICSE-007 1
B.Tech. -VIEP -COMPUTER SCIENCE AND
ENGINEERING (BTCSVI)
Term-End Examination
June, 2016
00866
BICSE-007 DISTRIBUTED DATABASE
Time hours Maximum Marks: 70
Note: Answer any seven questions. All questions carry equal marks.
1. Explain the general architecture of a parallel. database system and shared memory architecture. 10
2. Which process of DDBS design is used when we want to design DDBS from scratch Also draw and explain that process. 10
3. "Providing transparency is needed in DDBMS." Comment with suitable examples. 5
How does distributed transaction manager deal with multiple copies of data, when concurrency control is based on locking? 5
4. "Dynamic query optimization approach is best for Ad-hoc queries." -Write your comments on this statement by giving justification for your answer. 5
What is query optimization List the components of query optimizer software and explain anyone from that. 5
5. How can the correctness rules be applied to primary and derived horizontal fragmentation? 5
Define distributed deadlock detection. 5
6. Describe query decomposition and data localization in detail. 10
7. Explain ACID properties of transaction. 5
What are the lazy replication protocols? 5
8. Describe the fundamental approaches to construct a reliable system. 5
Explain the distributed cost model with an example. 5
9. Differentiate between federated database system and multi database system. 5
Explain three-phases commit protocol in detail. 5
10. Write short notes on any two of the following: 2x5=10
Scheduler
2PC
Fragmentation of database
Other Question Papers
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 P r o g r a m m i n g
- 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