NOSQL_Even_2024-2025

In database internals, what is the primary function of the buffer manager?

• Handles transactions and rollback operations

• Manages indexes for faster data retrieval

• Caches frequently accessed data pages in memory

• Converts queries into execution plans

What is one of the main reasons organizations migrate from RDBMS to NoSQL databases?

• Increased need for ACID compliance

• Better handling of structured data

• Ability to scale horizontally with unstructured or semi-structured data

• Reduction in server costs due to SQL optimization

Which of the following is NOT a challenge faced when migrating from RDBMS to NoSQL?

• Data consistency trade-offs

• Schema design differences

• Complex JOIN operations

• Increased support for stored procedures

Which web framework is most commonly used with MongoDB in JavaScript applications?

• Django

• Flask

• Express.js

• Laravel

In a typical NoSQL-based web application, where is data primarily stored?

• In-memory cache only

• In a relational table format

• As key-value, document, or columnar storage

• Directly inside frontend JavaScript files

MySQL can be used as a NoSQL database by utilizing which storage engine?

• InnoDB

• MyISAM

• NDB

• JSON

What is one advantage of using MySQL as a NoSQL database instead of migrating to a native NoSQL system?

• Eliminates need for indexing

• Retains ACID transactions while supporting JSON documents

• Allows horizontal scalability like Cassandra

• Eliminates the need for structured query language

In a typical NoSQL migration process, which step is performed first?

• Deploying new NoSQL clusters

• Identifying data models and access patterns

• Moving indexes to NoSQL

• Running production queries on the NoSQL system

Which NoSQL database is widely used with Django through Django ORM extensions?

• Cassandra

• CouchDB

• MongoDB

• Neo4j

Why do modern web applications prefer NoSQL databases over RDBMS?

• NoSQL supports strong consistency across distributed systems
  
  
  

• NoSQL is optimized for structured tabular data

• NoSQL offers flexibility and high scalability for big data applications

• NoSQL eliminates the need for database queries