NOSQL PART 2 WITH COMPLETE SOLUTIONS 100% CORRECT
Question 2: Why is it important to understand general concepts before handling NoSql
databases - ANSWER Answer: General concepts provide a foundation for the proper
use and understanding of NoSql databases
Question 3: Name any reasons discussed in favor of 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 the properties that ensue the
reliability of a database and its transactions.
Question 5: Mention some of the advantages of 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: Mappings from relational databases to object-oriented structures tend to be
painful, schema change is a complex and difficult operation to perform, scalability and
high availability were limited, and the licensing model was relatively expensive.
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 ranking of MongoDB about the popularity of databases currently
- ANSWER Answer: MongoDB presently ranks 5th in popularity among databases
Question 9: Why is NoSql database gaining momentum - ANSWER Answer: NoSql
databases have relative advantages in processing massive volumes of data,
, non-relational data, and specialized needs like document storage, search, and real-time
analytics
Question 10: Limitations of relational databases when dealing with diverse data sources
- ANSWER Answer: Relational databases have a problem when there is an unstructured
or non-relational source of data, for example, data from search engines, data streams,
etc.
Question 11: Some general concepts that needs to be understood before handling
NoSql databases - ANSWER Answer: ACID, performance, high-availability, and the
limitations of relational databases
Questions 12: Why are classic relational databases not a good fit for handling big data -
ANSWER Answer: Relational databases have limited scalability and performance to
scale 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 purpose of denormalization in tables used in OLAP - ANSWER
Answer: Denormalization in OLAP tables allows posting 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 elaborate, involving conversion
scripts and possible effects on existing data
Question 17: What is the primary benefit that NoSql databases have when dealing with
varied data sources - ANSWER Answer: The advantages of NoSql databases are that
they handle unstructured or non-relational data sources better than relational
Question 2: Why is it important to understand general concepts before handling NoSql
databases - ANSWER Answer: General concepts provide a foundation for the proper
use and understanding of NoSql databases
Question 3: Name any reasons discussed in favor of 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 the properties that ensue the
reliability of a database and its transactions.
Question 5: Mention some of the advantages of 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: Mappings from relational databases to object-oriented structures tend to be
painful, schema change is a complex and difficult operation to perform, scalability and
high availability were limited, and the licensing model was relatively expensive.
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 ranking of MongoDB about the popularity of databases currently
- ANSWER Answer: MongoDB presently ranks 5th in popularity among databases
Question 9: Why is NoSql database gaining momentum - ANSWER Answer: NoSql
databases have relative advantages in processing massive volumes of data,
, non-relational data, and specialized needs like document storage, search, and real-time
analytics
Question 10: Limitations of relational databases when dealing with diverse data sources
- ANSWER Answer: Relational databases have a problem when there is an unstructured
or non-relational source of data, for example, data from search engines, data streams,
etc.
Question 11: Some general concepts that needs to be understood before handling
NoSql databases - ANSWER Answer: ACID, performance, high-availability, and the
limitations of relational databases
Questions 12: Why are classic relational databases not a good fit for handling big data -
ANSWER Answer: Relational databases have limited scalability and performance to
scale 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 purpose of denormalization in tables used in OLAP - ANSWER
Answer: Denormalization in OLAP tables allows posting 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 elaborate, involving conversion
scripts and possible effects on existing data
Question 17: What is the primary benefit that NoSql databases have when dealing with
varied data sources - ANSWER Answer: The advantages of NoSql databases are that
they handle unstructured or non-relational data sources better than relational
