Scribd
Upload
7 views2 pages

No SQLMid QP

This document outlines the mid-examination details for the MCA program at GITAM School of Science, focusing on the course 'Introduction to NoSQL Database'. It includes the exam date, duration, and topics covered, along with a structured format of questions divided into Section-A and Section-B, addressing various aspects of NoSQL databases. The questions assess knowledge on database generations, performance optimization, and specific NoSQL architectures and queries.

Uploaded by

shaikshahid152
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

No SQLMid QP

This document outlines the mid-examination details for the MCA program at GITAM School of Science, focusing on the course 'Introduction to NoSQL Database'. It includes the exam date, duration, and topics covered, along with a structured format of questions divided into Section-A and Section-B, addressing various aspects of NoSQL databases. The questions assess knowledge on database generations, performance optimization, and specific NoSQL architectures and queries.

Uploaded by

shaikshahid152
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

GITAM School of Science

GITAM (Deemed to be University)


Department of Computer Science
Mid – Examination

Program: MCA Semester: IV Max. 30


Marks:
Course CSCI7481 Course Introduction to NoSQL Category / Generic
Code: Name: Database Credits: Elective/ 3
Date: 24-02-2026 Portion: Unit-1, Unit-2, Unit-3 Time: 02:00 PM –
04:00 PM

Section-A (Each Question carries 1 Mark)

CO PO BT
1. A List any four key motivations for NoSQL evolution. CO PO1 L1
1
B List any four applications of NoSQL databases. CO PO1 L1
1
C Compare and Contrast Vertical and Horizontal Scaling CO PO1 L4
2
D Outline ACID and BASE properties. CO PO1 L2
2
E Explain about Scaling in MongoDB CO PO1 L2
3
F Outline any two Comparison operators in MongoDB with example queries. CO PO4 L2
3

___________________________________________________________________________________________

Section-B (Each Question Carries 8 Marks)

CO PO BT
UNIT-I
2 Explain different generations of databases. CO1 PO1 L2
(OR)
3 a. Analyze the role of RAM in improving query performance, write
throughput, and caching efficiency in NoSQL databases
(Performance optimization with RAM).
b. Explain impedance mismatch in database systems and discuss its CO1 PO2 L4
effects
UNIT-II
4 a. Explain MapReduce architecture with the help of an example.
b. Outline Brewer’s CAP Theorem. CO2 PO1 L2
(OR)
5 a. Explain Neo4j architecture with social networks or MOOC as
usecase.
b. Explain MongoDB architecture with the help of its architecture CO2 PO1 L2
diagram.
UNIT-II
6 Analyze and design MongoDB aggregation queries with College database CO3 PO4 L4
containing Student, Enrollment, Instructor, and Course collections to
derive the following
a. For each course, list the IDs of students enrolled in that course
[From Course].
b. Show each course with the number of students enrolled [From
Course].
c. List each student along with the instructors who are in the same
department as the student [From Student].
d. For each instructor, list the titles of the courses offered by their
department [From Instructor].
(OR)
7 Design MongoDB queries for the following CO3 PO4 L3
a. Course titles starting with “No”
b. A legitimate Mobile number, with starting digit between 6-9 and
with 10 digits.
c. Students in MCA and Joined in 2026 (use and operator).
d. Instructor from CS and name starting with “Dr.” .
e. Titles NOT starting with Data NOR ending with Lab.
f. Enrollments NOT ACTIVE NOR FAIL.
g. Enrollments whose grade is not A
h. Instructors whose name starts with Dr. OR contains Uppada

You might also like