NOSQL Systems Exam Questions With
Verified And Updated Answers
What is the main challenge of the traditional relational databases? - answer✔Managing of
semi-structured and unstructured data
NoSQL databases differ from relational databases in three main areas: data structure, data
models and development model. - answer✔True
No SQL Technology is ... - answer✔A new generation of databases that are relational,
distributed, open source, schemaless and horizontally scalable
The Benefits of NoSQL are... - answer✔High performance, horizontal scaling, flexible and simple
storage mechanism
The disadvantages of NoSQL are that they do not have a standardized query language, they do
not full support ACID properties, and in order to provide integrity extra programming must be
required. - answer✔True
The CAP Theorem means that... - answer✔A NoSQL database can support two of consistency,
availability or partition tolerance
The BASE properties of NoSQL mean that an application works and data is consistent all the
time. - answer✔False
The most common NoSQL databases support video, music, documents and text, altogether -
answer✔False
MongoDB is a graph database - answer✔False
Neo4j is a columnar database - answer✔False
What is a key-value store? - answer✔It is a system that stores values indexed by keys, can store
structured and unstructured data.
The key-value database Cassandra is more focused on availability and consistency than on fault
tolerance. - answer✔False
ALL RIGHTS RESERVED.
Cassandra as a key-value database is more recommended when... - answer✔The application
requires more availability and fault tolerance than consistency, when the application can
sacrifice ACID properties for performance and operational management advantages
In Cassandra as a key-value database, what are the main components of storage? -
answer✔Columns, super columns, families of columns and keyspace
What are the elements of a supercolumn? - answer✔An array of several columns
What are the elements of a column family? - answer✔Contains columns or grouped super-
columns that use a single, common RowKey
What are the elements of a keyspace? - answer✔Families of columns or family of supercolumns
Comparing Cassandra with relational databases, a column is analogous to... - answer✔An
attribute name in a table
Comparing Cassandra with relational databases, a keyspace is analogous to... - answer✔A
relational database without interrelations
Comparing Cassandra with relational databases, a column family is analogous to... - answer✔A
tuple of a relation
In terms of a relational model, what is an alternative name of a columnar database? -
answer✔Binary relational model.
Considering two rows R1 and R2; R1(c1,c2); R2(c1,c2) in a columnar database, how are the
columns physically stored on disk? - answer✔The same column data values are stored together
R1c1,R2,c1, R2c1, R2,c2
Implementing an OLAP database with a relational database performs better than a columnar
database - answer✔False
In the case of SAP IQ as a columnar database manager the use of SQL and supports of ACID
properties is possible. - answer✔True
MongoDB saves data structures in BSON files - answer✔True
What are the type of queries supported by MongoDB as a document database? -
answer✔MongoDB supports search by fields, indexing, rank queries, regular expressions, key-
value geospatial, text, summarization and MapReduce
What are the main components of MongoDB? - answer✔Collections, documents, indexes
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.
