Exam Details
| Subject | distributed databases | |
| Paper | ||
| Exam / Course | b.tech | |
| Department | ||
| Organization | Vardhaman College Of Engineering | |
| Position | ||
| Exam Date | May, 2018 | |
| City, State | telangana, hyderabad |
Question Paper
(AUTONOMOUS)
B. Tech VII Semester Supplementary Examinations, May 2018
(Regulations: VCE-R14)
DISTRIBUTED DATABASES
(Information Technology)
Date: 24 May, 2018 AN Time: 3 hours Max Marks: 75
Answer ONE question from each Unit
All Questions Carry Equal Marks
Unit I
1. Explain top-down design process with a suitable diagram. 8M
Explain various components of Distributed Database Management Systems.
7M
2. Explain the importance of the following:
i. Operator tree of query
ii. Equivalence transformation
8M
Explain the process of horizontal fragmentation with suitable example..
7M
Unit II
3. Briefly discuss the Complexity of Relational Algebra Operations. 8M
Explain the layers of query processing with a suitable diagram.
7M
4. Explain the characteristics of Query Processers. 8M
With an example describe semi-join programs as reducers.
7M
Unit III
5. Write the semijoin based query optimization algorithm. 7M
Give the comparison of join and semijoin approaches in distributed queries.
8M
6. Explain different phases of Optimistic and Pessimistic Transaction Execution. 8M
Explain the concept of wait-die and wound-wait rule for deadlock avoidance.
7M
Unit IV
7. List the different parallel system architectures and explain any two in detail. 8M
Explain hierarchical architecture in detail with a neat diagrammatic representation.
7M
8. What is load balancing? What are the different parallelisms where load balancing
problems occur? Explain the techniques for solving the same.
8M
Briefly explain the concept of Data Placement with respect to parallel DBMS techniques.
7M
Unit V
9. Define the following with respect to DBMS:
i. Class
ii. Composite Object
iii. Complex Object
iv. Collection
8M
Explain how derived horizontal fragmentation occurs.
7M
10. Explain object server architecture with a suitable diagram. 8M
Briefly describe pointer swizzling. 7M
B. Tech VII Semester Supplementary Examinations, May 2018
(Regulations: VCE-R14)
DISTRIBUTED DATABASES
(Information Technology)
Date: 24 May, 2018 AN Time: 3 hours Max Marks: 75
Answer ONE question from each Unit
All Questions Carry Equal Marks
Unit I
1. Explain top-down design process with a suitable diagram. 8M
Explain various components of Distributed Database Management Systems.
7M
2. Explain the importance of the following:
i. Operator tree of query
ii. Equivalence transformation
8M
Explain the process of horizontal fragmentation with suitable example..
7M
Unit II
3. Briefly discuss the Complexity of Relational Algebra Operations. 8M
Explain the layers of query processing with a suitable diagram.
7M
4. Explain the characteristics of Query Processers. 8M
With an example describe semi-join programs as reducers.
7M
Unit III
5. Write the semijoin based query optimization algorithm. 7M
Give the comparison of join and semijoin approaches in distributed queries.
8M
6. Explain different phases of Optimistic and Pessimistic Transaction Execution. 8M
Explain the concept of wait-die and wound-wait rule for deadlock avoidance.
7M
Unit IV
7. List the different parallel system architectures and explain any two in detail. 8M
Explain hierarchical architecture in detail with a neat diagrammatic representation.
7M
8. What is load balancing? What are the different parallelisms where load balancing
problems occur? Explain the techniques for solving the same.
8M
Briefly explain the concept of Data Placement with respect to parallel DBMS techniques.
7M
Unit V
9. Define the following with respect to DBMS:
i. Class
ii. Composite Object
iii. Complex Object
iv. Collection
8M
Explain how derived horizontal fragmentation occurs.
7M
10. Explain object server architecture with a suitable diagram. 8M
Briefly describe pointer swizzling. 7M
Subjects
- advanced computer networks
- advanced database management systems
- advanced digital signal processing
- advanced structural design
- air line management
- air pollution and control methodologies
- aircraft systems and instrumentation
- analog communications
- artificial intelligence
- automobile engineering
- basic electrical engineering
- basic mechanical engineering
- cad/cam
- cellular and mobile comunications
- cloud computing
- coding theory and techniques
- compiler design
- computational fluid dynamics
- computer architecture and parallel processing
- computer graphics
- computer graphics concepts
- computer networks
- computer organization and architecture
- computer programming
- computer vision and pattern recognition
- concrete technology
- control systems
- cyber security
- data mining and data warehousing
- database management systems
- design and drawing of hydraulic structures
- design for testability
- digital image processing
- distributed databases
- distributed operating systems
- electrical machines-ii
- electromagnetics and transmission lines
- electronic measurements and instrumentation
- embedded netwrok and protocols
- embedded software design
- embedded systems
- engineering drawing-i
- engineering mechanics-i
- engineering physics
- entrepreneurship
- environmental engineering-ii
- environmental science
- finite elements methods in civil engineering
- flexible ac transmission systems
- formal language and automata theory
- grid and cloud computing
- hardware software co-design
- heat transfer
- high voltage engineering
- hydraulic machines
- hydraulics and hydraulic machines
- image processing
- image processing and pattern recognition
- industrial management and psychology
- information retrieval systems
- instrumentation and control systems
- kinematics of machinery
- low power cmos vlsi design
- managerial economics and financial analysis
- microwave engineering
- mobile application development through j2me
- national service scheme
- network security and cryptography
- operating systems
- operations research
- pavement analysis and design
- planning and drawing
- power electronic control of ac drives
- power electronic converters-ii
- power semiconductor drives
- power system generation
- power system switchgear and protection
- principles of electrical engineering
- principles of programming languages
- probability theory and numerical methods
- production technology-i
- programmable logic controllers and applications
- project planning and management
- pulse and digital circuits
- reactive power compensation and management
- refrigeration and air conditioning
- rehabilitation and retrofitting structures
- reliability engineering
- renewable energy sources
- robotics and automation
- satellite and radar communications
- service oriented architecture
- signals and systems
- software architecture
- software engineering
- software project management
- software testing and quality assurance
- speech signal processing
- strength of materials-iibuilding
- structural analysis-i
- surveying-ii
- technical english
- thermal engineering-i
- utilization of electrical energy
- vlsi design
- web technologies
- wireless and mobile computing
- wireless communications and networks