BHASKAR ENGINEERING COLLEGE
III B. Tech. I Sem. I Mid-Term Examinations SEP 2025 Set-1
Subject Name : Distributed Databases
Branch:(AIML),AIDS Max Marks: 30 Time: -2Hours
NAME: _________________________ Hall Ticket No. _______________________________
Marks : 10
Choose the correct answer
1. Which component of the DBMS is responsible for parsing and optimizing SQL queries before
execution? ( )
a) Query Processor b) Storage Manager c) Transaction Manager d) Buffer Manager
2. In a three-level DBMS architecture, which level provides the user view of the database? ( )
a) External level b) Physical level c) Conceptual level d) Internal level
3. What is the main purpose of the conceptual level in DBMS architecture? ( )
a) To define the physical storage of data b) To manage network connections
c) To describe the structure of the entire database d) To provide user-specific views
4. What does the query optimizer use to estimate the cost of different query plans? ( )
a) Network bandwidth b) User preferences
c) Database schema d) Statistics about data distribution
5. What is the purpose of query decomposition in DBMS? ( )
a) To convert queries into machine code b) To encrypt queries for security
c) To break down complex queries into simpler subqueries d) To store queries in the catalog
Fill in the blanks
1. The ______________________ optimizer selects the most efficient execution plan for a query.
2. The final phase of query processing is _______ , where the query is actually run on the database.
3. The first step in query processing is_____________________, which checks the syntax and
semantics of the query.
4. Logical data independence is achieved at the __________ level of DBMS architecture.
5. The DBMS _________ stores metadata such as schema definitions and user privileges.
Answer Any Four Question 4*5=20
1. Explain the Eploitation of network topology.
2. List and explain types of transactions with suitable diagrams.
3. Draw and explain distributed database management system architecture.
4. Explain in detail about the data processing in DDBSs.
5. Discuss the semi joins in query optimization.
6. Identify the need to have distributed databases , and distinguish the features of distributed
databases with centralized databases.
BHASKAR ENGINEERING COLLEGE
III B. Tech. I Sem. I Mid-Term Examinations SEP 2025 Set-2
Subject Name : Distributed Databases
Branch: (AIML),AIDS Max Marks: 30 Time: -2Hours
NAME: _________________________ Hall Ticket No. _______________________________
Marks : 10
Choose the correct answer
1. Which of the following best describes data independence in DBMS? ( )
a) Ability to encrypt data for security
b) Ability to store data in multiple formats
c) Ability to change data without affecting application programs
d) Ability to access data from multiple databases
2. Which level of DBMS architecture deals with the physical storage of data? ( )
a) Conceptual level b) External level c) Internal level d) Logical level
3. Which of the following is NOT a phase in query processing? ( )
a) Query execution b) Query parsing c) Query encryption d) Query optimization
4. What is the first step in query processing in a DBMS?
a)Query optimization b) Query decomposition c) Query execution d) Query parsing
5. Which component of the DBMS is responsible for transforming a high-level query
into an efficient execution plan?
a) Query parser b) Storage manager c) Query optimizer d) Transaction manager
Fill in the blanks
1. The __________ level in DBMS architecture provides the user view of the data.
2. The __________ level hides the physical storage details from users.
3. The __________ manager is responsible for managing disk storage and data retrieval.
4. Query __________ involves breaking down complex queries into simpler subqueries.
5. The query optimizer uses __________ about data distribution to estimate query costs.
Answer Any Four Question 4*5=20
1. Explain the SDD-1 distributed query optimization algorithms in brief.
2. Discuss in detail the query decomposition successive steps.
3. Differentiate between centralized 2PL protocol and Distributed 2PL protocol.
4. Explain about the query processing layers with an examples.
5. Discuss about the normalization in query decomposition.
6. Explain the horizontal fragmentation in distributed databases.
