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
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TheStar. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
