DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Not based on the relational model
|
|
|
Support large amounts of sparse data
|
|
|
Store data in key-value stores
|
|
|
Geared toward performance rather than transaction consistency
|
|
|
none of the above
|
Detailed explanation-1: -Which of the following is true of NoSQL databases? They are geared toward transaction consistency rather than performance. They do not support very large amounts of sparse data.
Detailed explanation-2: -Which of the following statements is true of NoSQL databases? They don’t support any Structured Query Language (SQL) functions. They are useful for managing large sets of distributed data.
Detailed explanation-3: -True, NoSQL databases ("not only SQL") are non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph. Hence the correct answer is Only statement 2 is true.
Detailed explanation-4: -NoSQL is not suitable for storing structured data. NoSQL databases allow storing non-structured data.
Detailed explanation-5: -NoSQL databases have the following properties: They have higher scalability. They use distributed computing. They are cost effective.