Exam Details
| Subject | distributed databases | |
| Paper | ||
| Exam / Course | computer science and engineering | |
| Department | ||
| Organization | Vardhaman College Of Engineering | |
| Position | ||
| Exam Date | May, 2018 | |
| City, State | telangana, hyderabad |
Question Paper
VARDHAMAN COLLEGE OF ENGINEERING
(AUTONOMOUS)
B. Tech VI Semester Regular Examinations, May 2018
(Regulations: VCE-R15)
DISTRIBUTED DATABASES
(Common to Computer Science and Engineering Information Technology)
Date: 24 May, 2018 FN
Time: 3 hours
Max Marks: 75
Answer ONE question from each Unit
All Questions Carry Equal Marks
Unit I
1.
With a neat diagram, discuss the detailed components of a distributed DBMS.
7M
What is a fragment of a relation? Explain with an example Hybrid Fragmentation.
8M
2.
Discuss an allocation model that attempts to minimize the total cost of processing and storage.
7M
With a neat diagram, explain framework for top-down design process and show relationship between each component.
8M
Unit II
3.
Discuss Generic Layering Scheme for Distributed Query Processing.
7M
With the example of an operator tree explain Query Decomposition with six most useful equivalence rules, which concern the basic relational algebra operators.
8M
4.
With an appropriate example explain the reduction for Primary Horizontal Fragmentation based on selection predicates and joins.
7M
Discuss four characteristics hold for both centralized and distributed query processors.
8M
Unit III
5.
What is Query optimization? Explain the different stages of query optimization with respect to an minimizes an objective cost function.
7M
Discuss Timestamp-Based Concurrency Control Algorithms with two properties.
8M
6.
What are the advantages and drawback of Dynamic and static query optimization?
7M
Explain deadlock management approach with a suitable example.
8M
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
Explain distributed database server organization with a neat diagrammatic representation.
7M
Unit V
9.
Explain the different approaches on which the class partitioning algorithms are based on.
7M
Define the following with respect to DDBMS:
i. Class
ii. Composite Object
iii. Complex Object
iv. Collection
8M
10.
List the different kinds of partitioning available for distributed object DBMS and explain any one.
7M
Explain data allocation problem for object databases.
8M
(AUTONOMOUS)
B. Tech VI Semester Regular Examinations, May 2018
(Regulations: VCE-R15)
DISTRIBUTED DATABASES
(Common to Computer Science and Engineering Information Technology)
Date: 24 May, 2018 FN
Time: 3 hours
Max Marks: 75
Answer ONE question from each Unit
All Questions Carry Equal Marks
Unit I
1.
With a neat diagram, discuss the detailed components of a distributed DBMS.
7M
What is a fragment of a relation? Explain with an example Hybrid Fragmentation.
8M
2.
Discuss an allocation model that attempts to minimize the total cost of processing and storage.
7M
With a neat diagram, explain framework for top-down design process and show relationship between each component.
8M
Unit II
3.
Discuss Generic Layering Scheme for Distributed Query Processing.
7M
With the example of an operator tree explain Query Decomposition with six most useful equivalence rules, which concern the basic relational algebra operators.
8M
4.
With an appropriate example explain the reduction for Primary Horizontal Fragmentation based on selection predicates and joins.
7M
Discuss four characteristics hold for both centralized and distributed query processors.
8M
Unit III
5.
What is Query optimization? Explain the different stages of query optimization with respect to an minimizes an objective cost function.
7M
Discuss Timestamp-Based Concurrency Control Algorithms with two properties.
8M
6.
What are the advantages and drawback of Dynamic and static query optimization?
7M
Explain deadlock management approach with a suitable example.
8M
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
Explain distributed database server organization with a neat diagrammatic representation.
7M
Unit V
9.
Explain the different approaches on which the class partitioning algorithms are based on.
7M
Define the following with respect to DDBMS:
i. Class
ii. Composite Object
iii. Complex Object
iv. Collection
8M
10.
List the different kinds of partitioning available for distributed object DBMS and explain any one.
7M
Explain data allocation problem for object databases.
8M
Other Question Papers
Subjects
- advanced algorithms
- advanced algorithms laboratory
- advanced data communications
- advanced data structures
- advanced data structures laboratory audit course – i
- advanced mechanics of solids
- advanced mechanisms
- advanced operating systems
- advanced operating systems laboratory
- artificial intelligence and neural networks
- business analytics
- cloud computing
- cloud computing laboratory
- cmos vlsi design
- computer graphics
- computer organization and architecture
- computer vision and pattern recognition
- constitution of india
- cpld and fpga architectures and applications
- cryptography and computer security
- data warehousing and data mining
- datawarehousing and data mining
- design patterns
- digital image processing
- digital systems design
- disaster management
- distributed computing
- distributed databases
- distributed operating systems
- dsp processors and architectures
- embedded linux
- embedded real time operating systems
- embedded systems
- energy conversion systems
- english for research papers writing
- entrepreneurship development
- finite element methods
- fracture, fatigue and creep deformation
- human computer interaction
- image processing
- industrial safety
- information retrieval systems
- information security
- machine learning
- major project phase-i
- major project phase-ii
- microcontrollers for embedded system design
- mini project with seminar audit course – ii
- mobile computing
- mobile satellite communications
- national service scheme
- number theory and cryptography
- object oriented analysis and design
- operations research
- pedagogy studies
- personality development through life enlightenment skills
- power electronic control of dc drives
- power electronic converters-i
- power semi conductor devices
- principles of machine modeling analysis
- research methodology and intellectual property rights
- sanskrit for technical knowledge
- semantic web and social networks
- software engineering principles
- solar, energy and applications
- stress management by yoga
- system modeling and simulation
- value education
- waste to energy
- web security
- wireless and mobile computing