ELEVATE SKILLS!
Enquiry FormRSSBRPSCUniversity of RajasthanRTU KotaCareers@SA
ELEVATE SKILLS!

CS Free MCQ Bank

Access a comprehensive computer science MCQ bank for free, featuring hundreds of questions with detailed solutions. Strengthen concepts, practice effectively, and prepare confidently for exams, quizzes, and competitive tests.

  • Home
  • CS MCQs
  • DBMS
  • Suraku Academy | DBMS - NoSQL Modern Database Solved MCQs & PYQs Bank

Q: 1 ORDBMS is an:

  1. Extension of OODBMS

  2. Extension of RDBMS

  3. Any of the above

  4. All of the above

[ Option B ]

An ORDBMS (Object-Relational Database Management System) combines the features of relational databases with object-oriented concepts. It is called an extension of RDBMS because it is built on the relational model and adds object-oriented features to it.

Q: 2 Advantages of a distributed database include:

  1. Sharing data

  2. Autonomy

  3. Availability

  4. All of the above

[ Option D ]

A distributed database stores data across multiple locations but appears as a single database to users.

  • Sharing data allows users at different sites to access the same data.
  • Autonomy means each site can operate independently and manage its own data.
  • Availability is improved because if one site fails, data can still be accessed from another site.

Q: 3 Which is not a type of NoSQL?

  1. CouchDB

  2. MongoDB

  3. HBase

  4. QBase

[ Option D ]

NoSQL (Not Only SQL) databases are non-relational databases designed to handle large volumes of unstructured or semi-structured data. They are categorized into different types based on their data models: document-based, key-value, column-family, and graph databases.

NoSQL DatabaseTypeDescription
MongoDBDocument-OrientedStores data in BSON (Binary JSON), flexible schema, widely used in web apps and analytics for its scalability and flexibility.
CouchDBDocument-OrientedJSON-based documents, supports replication and offline storage. It is good for distributed applications.
HBaseColumn-FamilyHandles very large datasets across clusters, modeled after Bigtable, It is used in big data.
RedisKey-ValueIn-memory database, extremely fast and  used for caching, session management, real-time analytics.
CassandraColumn-FamilyHighly scalable and fault-tolerant, ideal for big data and real-time applications.
Neo4jGraphStores data as nodes and relationships, excellent for social networks, recommendations, and network analysis.
DynamoDBKey-Value / DocumentFully managed by AWS (Amazon Web Services) scalable, low-latency access. It is  supports both key-value and document models.
  • JSON (JavaScript Object Notation) is a lightweight, text-based data format used to store and exchange data. It represents data as key-value pairs organized in objects and arrays, making it easy for humans to read and write, and for machines to parse and generate. 
  • JSON is widely used in web applications to transfer data between clients and servers. In NoSQL databases, JSON is often the native format for storing data.

Q: 4 In which type of Database Management System is information distributed across different sites?

  1. OODBMS

  2. RDBMS

  3. DDBMS

  4. None of these

[ Option C ]

A Distributed Database Management System (DDBMS) stores and manages data at multiple physical locations called sites, but presents it to users as a single logical database. This improves data availability, reliability, and performance.

Q: 5 Scalability in a database refers to the ability of a system to:

  1. Be modified, expanded, or downsized easily to meet changing requirements

  2. Share data across the enterprise so that more users can access more data

  3. Maintain consistent standards for data names, formats, and documentation

  4. Remain independent of how physical data is stored and maintained

[ Option A ]

Scalability means the ability of a system to grow or shrink in capacity such as handling more users, more data, or higher workload without major redesign.

Q: 6 In Object-Relational Data Models, which of the following is true about attributes of tuples?

  1. Only scalar atomic value attributes are allowed.

  2. Only string value attributes are allowed.

  3. Attributes of complex types including nested relation are allowed.

  4. Only Boolean value attributes are allowed.

[ Option C ]

In Object-Relational Data Models (ORDM), the traditional relational restriction that each attribute must be atomic is relaxed. Tuples can have attributes of complex types, such as nested relations, arrays, or objects. This allows the database to better model real-world entities and relationships while retaining relational principles.

Q: 7 What are the maximum number of spanning trees (Tn) possible for a complete graph K5 on 5 vertices?

  1. 100

  2. 20

  3. 200

  4. 125

[ Option D ]

A spanning tree of a graph is a tree that connects all the vertices without forming any cycle.
For a complete graph Kn ,where every vertex is connected to every other vertex, the number of possible spanning trees is given by Cayley’s formula, Tn=nn−2.
Here, n = 5 so, T5=55−2 = 53 = 125.

Thank You for Reading!

Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.

Don’t forget to subscribe and stay connected for future updates.