©THESTAR EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
NOSQL PART 2 Exam Questions With
Verified And Updated Answers
Question 2: Why is it important to understand general concepts before handling NoSql
databases - answer✔Answer: General concepts provide a foundation for correctly using and
understanding NoSql databases
Question 3: What are some reasons discussed for exploring alternatives to relational databases
- answer✔Answer: Performance and high-availability issues, limitations with handling big data
Question 4: What is ACID in the context of databases - answer✔Answer: ACID stands for
Atomic, Consistent, Isolated, and Durable, which are properties that ensure the reliability of a
database and its transactions
Question 5: What are the advantages of using relational databases - answer✔Answer: Wide
range of tools and know-how available, support for the ACID principle, powerful SQL language,
and availability of drivers and frameworks for accessing databases
Question 6: What are some disadvantages of using relational databases - answer✔Answer:
Difficulties in mapping between relational databases and object-oriented structures,
complexities in handling schema changes, limitations in scalability and high availability, and
expensive licensing models
Question 7: Name four major players in the relational database market.
Answer: Oracle, MySql, Microsoft SQL Server, and Postgres - answer✔
Question 8: What is the current ranking of MongoDB in the popularity of databases -
answer✔Answer: MongoDB is currently the 5th most popular database
Question 9: Why are NoSql databases gaining popularity - answer✔Answer: NoSql databases
offer advantages in handling large volumes of data, non-relational data structures, and specific
use cases such as document storage, search, and real-time analytics
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
Question 10: What are some limitations of relational databases when dealing with diverse data
sources - answer✔Answer: Relational databases struggle with unstructured or non-relational
data sources, such as data from search engines or data streams
Question 11: What are some general concepts that need to be understood before handling
NoSql databases - answer✔Answer: Concepts such as ACID, performance, high-availability, and
the limitations of relational databases
Question 12: Why are classical relational databases not a good fit for handling big data -
answer✔Answer: Relational databases have limitations in scalability and performance when
dealing with large volumes of data
Question 13: What are the four main characteristics of the ACID principle - answer✔Answer:
Atomic, Consistent, Isolated, and Durable
Question 14: What are some challenges in mapping between relational databases and object-
oriented structures - answer✔Answer: Handling primary keys, foreign keys, n-to-n
relationships, and inheritance
Question 15: What is the significance of denormalization in tables used in OLAP -
answer✔Answer: Denormalization is used in OLAP tables to improve performance by
reintroducing redundancy in the data
Question 16: What are some common disadvantages of schema changes in relational databases
- answer✔Answer: Schema changes can be complex, requiring conversion scripts and
potentially impacting existing data
Question 17: What is the main advantage of NoSql databases in handling diverse data sources -
answer✔Answer: NoSql databases can handle unstructured or non-relational data sources
more effectively than relational databases
Question 18: What are some examples of NoSql databases apart from MongoDB -
answer✔Answer: Cassandra, Redis, and ElasticSearch are popular NoSql databases
Question 19: Why do programming projects usually choose object-oriented languages like Java
or Python - answer✔Answer: Object-oriented languages provide flexibility and are widely
supported in the development community
Question 20: Why are alternative databases like NoSql not commonly considered for projects -
answer✔Answer: Relational databases are often assumed to be the default choice without
considering the advantages of alternative databases like NoSql
2|Page
ALL RIGHTS RESERVED.
NOSQL PART 2 Exam Questions With
Verified And Updated Answers
Question 2: Why is it important to understand general concepts before handling NoSql
databases - answer✔Answer: General concepts provide a foundation for correctly using and
understanding NoSql databases
Question 3: What are some reasons discussed for exploring alternatives to relational databases
- answer✔Answer: Performance and high-availability issues, limitations with handling big data
Question 4: What is ACID in the context of databases - answer✔Answer: ACID stands for
Atomic, Consistent, Isolated, and Durable, which are properties that ensure the reliability of a
database and its transactions
Question 5: What are the advantages of using relational databases - answer✔Answer: Wide
range of tools and know-how available, support for the ACID principle, powerful SQL language,
and availability of drivers and frameworks for accessing databases
Question 6: What are some disadvantages of using relational databases - answer✔Answer:
Difficulties in mapping between relational databases and object-oriented structures,
complexities in handling schema changes, limitations in scalability and high availability, and
expensive licensing models
Question 7: Name four major players in the relational database market.
Answer: Oracle, MySql, Microsoft SQL Server, and Postgres - answer✔
Question 8: What is the current ranking of MongoDB in the popularity of databases -
answer✔Answer: MongoDB is currently the 5th most popular database
Question 9: Why are NoSql databases gaining popularity - answer✔Answer: NoSql databases
offer advantages in handling large volumes of data, non-relational data structures, and specific
use cases such as document storage, search, and real-time analytics
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
Question 10: What are some limitations of relational databases when dealing with diverse data
sources - answer✔Answer: Relational databases struggle with unstructured or non-relational
data sources, such as data from search engines or data streams
Question 11: What are some general concepts that need to be understood before handling
NoSql databases - answer✔Answer: Concepts such as ACID, performance, high-availability, and
the limitations of relational databases
Question 12: Why are classical relational databases not a good fit for handling big data -
answer✔Answer: Relational databases have limitations in scalability and performance when
dealing with large volumes of data
Question 13: What are the four main characteristics of the ACID principle - answer✔Answer:
Atomic, Consistent, Isolated, and Durable
Question 14: What are some challenges in mapping between relational databases and object-
oriented structures - answer✔Answer: Handling primary keys, foreign keys, n-to-n
relationships, and inheritance
Question 15: What is the significance of denormalization in tables used in OLAP -
answer✔Answer: Denormalization is used in OLAP tables to improve performance by
reintroducing redundancy in the data
Question 16: What are some common disadvantages of schema changes in relational databases
- answer✔Answer: Schema changes can be complex, requiring conversion scripts and
potentially impacting existing data
Question 17: What is the main advantage of NoSql databases in handling diverse data sources -
answer✔Answer: NoSql databases can handle unstructured or non-relational data sources
more effectively than relational databases
Question 18: What are some examples of NoSql databases apart from MongoDB -
answer✔Answer: Cassandra, Redis, and ElasticSearch are popular NoSql databases
Question 19: Why do programming projects usually choose object-oriented languages like Java
or Python - answer✔Answer: Object-oriented languages provide flexibility and are widely
supported in the development community
Question 20: Why are alternative databases like NoSql not commonly considered for projects -
answer✔Answer: Relational databases are often assumed to be the default choice without
considering the advantages of alternative databases like NoSql
2|Page
