UNIT – I: Database System Architecture
1. Explain Two-tier and Three-tier client-server architecture with neat diagram.
2. Describe Database System Architecture with its components.
3. Compare Two-tier and Three-tier architecture (any four points).
4. Define DBMS. Explain its functions and architecture.
5. Define Data Independence and state its types.
6. Explain Functions of Database Administrator (DBA).
7. Explain Centralized Database System with diagram.
8. State advantages and disadvantages of Client/Server Database System.
9. Explain layers of DBMS architecture (internal, conceptual, external).
10. Draw and explain Distributed Database Architecture.
11. Describe approaches for Machine learning :
UNIT – II: Parallel and Distributed Database System
1. Define Parallel Database and state types of parallelism.
2. Compare Parallel and Distributed Database (any four/six points).
3. Draw and explain Architecture of Parallel Database System.
4. Draw and explain Architecture of Distributed Database System.
5. State and explain benefits of Distributed Database System.
6. Explain Data Fragmentation (Horizontal & Vertical) with example.
7. Explain Replication and Data Allocation strategies.
8. Define Lock and explain Two Phase Locking Protocol with example.
9. Explain Concurrency Control and Commit Protocols.
10. Explain Data Synchronization in Mobile Database.
UNIT – III: Object-Based Database & XML
Object-Based Database
1. Explain Object identity and Reference types in SQL with example.
2. Explain Arrays and Multiset types in SQL with example.
3. Explain Complex data types with example.
4. Write syntax and example for Nested Query.
5. Explain Structured types and Inheritance in SQL.
6. Define Object-Oriented Database (OODB). State its features.
7. Compare Structured and Unstructured data.
XML (Extensible Markup Language)
8. Explain Structure of XML document with example.
9. Define XML Schema and explain its use.
10. Compare XPath and XQuery (any four points).
11. Explain FLWOR (FLOWR) Expression in XQuery with example.
12. Write XQuery to select:
o All book titles from a given XML file.
o All books where price < 30.
UNIT – IV: NoSQL & MongoDB
1. Define NoSQL. State its types.
2. Write any four benefits of NoSQL database system.
3. Compare SQL and NoSQL (any four points).
4. Name any four common MongoDB data types.
5. Explain basic operations with MongoDB shell (db, use, show dbs).
6. Explain the use of find() command in MongoDB with examples.
7. Emp (E_id, E_name, job_id, Salary, dept_id) Dept (dept_id, dept_name, location)
(i) Find all employees who locate in ‘London’ and whose salary is
greater than 60,000 INR.
(ii) Display department information of those employee whose job_id =
20.
(iii) Find the departmental name of employee whose salary is greater
than average salary. Write XML expression / join for above
statements.
8. Write query to execute find ( ) function on Collection : Inventory
i) To display all documents in the collection.
ii) To display all documents where the status equal "D".
iii) To display all documents where the status equals either "A" or "D".
iv) To display all documents where the status equals "A" and qty. is less than30.
v) To display all documents where the status equals "A" or qty. is > than 30.
vi) To display all documents where the status equals "A" and either qty. is less
than 30 or item starts with character p.
9. Write queries using find():
o Display all documents where status = "A" or "G".
o Display documents where quality < 40 and > 20.
o Display all documents in a collection.
10. Explain Aggregation pipeline with example.
11. State the use of aggregate() function.
12. Explain MongoDB Data Model and its features.
13. Write output for the following command executed on Mongo DB shell.
o i) > New date ("2023/7/9"/;
o ii) > "Welcome, MSBTE". replace ("MSBTE", "MongoDB");
UNIT – V: Data Mining and Warehousing
1. Define Data Warehouse. Enlist its characteristics.
2. Define Data Mart and Metadata.
3. Explain Architecture of Data Warehouse with diagram.
4. Draw and explain Data Warehousing Life Cycle.
5. Compare Data Warehouse and Data Mining (any 6 points).
6. Enlist and explain Applications of Data Mining.
7. Explain OLAP and OLTP with examples.
8. Explain Business Intelligence (BI) Framework / Components.
9. Explain ETL (Extract, Transform, Load) process in Data Warehouse.
10. Describe advantages and limitations of Data Mining.
11. Write short note on Hadoop.
12. Draw and explain architecture of Hadoop.
13. Consider following input data for your Map Reduce program: Welcome to Hadoop
class
Hadoop is good
Hadoop is bad
Draw Map Reduce architecture and explain its phases.
Unlock your future with our expert-led Polytechnic Classes!
Email: [Link]@[Link]
Join us: [Link]
This document is prepared for educational purposes only. The questions included are based on the syllabus and may or may not appear in the
actual MSBTE exam. Accuracy is not guaranteed, and the authors or distributors are not responsible for any errors, omissions, or
consequences arising from its use. Students should use this material only as a supplementary study aid.