USN
DAYANANDA SAGAR ACADEMY OF TECHNOLOGY & MANAGEMENT
(An Autonomous Institute under VTU, Belagavi)
First Semester MCA Semester End Examination - April 2025
Course: NOSQL
Course Code: MMC345
Max Marks: 100 Duration: 03 Hours
Note:
1. Answer any FIVE full questions, choosing at least ONE question from each MODULE
2. Any missing Data can be suitably assumed.
Module - 1 Marks BL CO
Explain the key differences between NoSQL and traditional relational
Q.1 a databases? 10 L1 CO1
Why are unstructured and semi-structured data are not suitable for
b 10 L2 CO1
RDBMS?
OR
a What is NoSQL and explain its history and the necessity for NoSQL 10 L1 CO1
databases.
Explain the key differences between ACID and CAP?
b 10 L2 CO1
Q.2
Module – 2
Discuss the concept of a document-type database, how data is represented
a in it, and provide a suitable example. 10 L2 CO1
Q.3
Apply CRUD operations in MongoDB to address the given scenario
b 10 L3 CO2
Scenario: You are building a library management system to track books
and their availability. The database needs to store details such as the book
title, author, genre, publication year, and whether the book is currently
issued.
Create: Create a new book collection.
Retrieve: Retrieve a list of books by a specific genre.
Update: Update the status of a book when it is issued or returned.
Delete: Delete a book from the collection based on its name.
OR
Explain the concept of indexing and discuss how indexing used for fast
a 10 L2 CO1
query retrieval in MongoDB with an example
Q.4 Apply and provide examples for the usage of the following MongoDB
b 10 L3 CO2
commands: a) $set b) $match c) $project d) $group e) $sum.
Module – 3
10 L3 CO2
a Illustrate the working of Hive by performing CRUD operations. Compare its
functionality with traditional RDBMS
Q5 Analyze the MapReduce operation for the following scenario: 10 L4 CO3
b
Scenario: A university stores student records, including their department
and marks in different subjects. The university administration wants to
identify the highest marks obtained by any student in each department.
Explain how MapReduce can be used to retrieve this information and
provide the equivalent MongoDB find operation for this scenario
OR
Illustrate the following commands in Amazon SimpleDB with an Example
a a) simpledb create-domain b) simpledb put c)simpledb put-replace 10 L3 CO2
Q.6 d) simpledb delete e) simpledb list-domains
Analyze the following Google App Engine (GAE) data persistence models in
b the cloud with an examples 10 L4 CO3
a) Model b)Expando c) PolyModel
Module – 4
Describe the following MongoDB storage commands with an example
a dataSize() 10 L2 CO1
Q.7 storageSize()
totalSize()
totalIndexSize()
validate().
Illustrate the MongoDB Wire Protocol using any of the CRUD operations.
b 10 L3 CO2
OR
Outline how NoSQL solutions like Memcached and HandlerSocket work with
a MySQL to enhance performance 10 L2 CO1
Q.8 Illustrate the support for NoSQL databases provided by web frameworks
b 10 L3 CO2
Module – 5
Explain the advantages of using NoSQL databases over relational
a databases for web applications. 10 L2 CO1
Q.9 Design a schema in MongoDB for a blog application and explain the
b relationships between collections. 10 L4 CO3
OR
Describe the process of creating and managing users in MongoDB. How is
a role-based access control (RBAC) implemented? 10 L2 CO1
Q.10
b Develope a PHP code snippet to implement a blog post submission form 10 L4 CO3
with data store in MongoDB.