Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

DATA base MCQ Which of the following is/are correct? Select one or more: O a. So

ID: 3601827 • Letter: D

Question

DATA base MCQ

Which of the following is/are correct? Select one or more: O a. Some NoSQL databases partially support the concept of schema, which also allows to add indexes. O b. NoSQL databases generally don't require a rigid schema before inserting data. O c. The concept of schema in NoSQL databases is often flexible, which allows programmers to modify data structure at runtime. d. NoSQL databases do not support schema at all. What are the reasons for considering a NoSQL database, rather than a relational database? Select one or more: a. Complex transactions can be performed to preserve consistency across difference transactions. b. Data is growing fast and changing in structure, which requires a database to scale out quickly. c. A database can allow the insertion of data without a pre-defined schema O d. A declarative query language is preferred for querying data and managing data integrity. Which of the following is/are correct? Select one or more: a. Some NoSQL databases let the programmer decide the trade-off between scalability and consistency b. Some NoSQL databases offer eventual consistency. c. Some NoSQL databases offer limited transactions. d. There are no transactions in any NoSQL databases 0

Explanation / Answer

1. The correct options are a & c.

The reason is that nosql consists of schema and one can change it in the runtime . It is quite flexible and hence, is one of the most decorated and celebrated concept in the databases.

2. The correct options are b, c & d.

The reason behind this is that the data is been increasing very effectively and it is true that there is need of query language and database that is easy to maintain and alter. NoSQL databases are built to allow the insertion of data without a predefined schema.

3. The correct options are b & c.

The reason is that there are transactions in NoSQL but they provide limited transactions as they are lighter weighted than what is been consisted of the relational databases.

4. The correct options are c,e,f.

The column oriented databases are those databases in which there is no need of determining the structure.

5. The correct options are a, b, d.

These are all used to describe the structure of the MongoDB.

Rate an upvote....Thankyou

Hope this helps...