Exam (elaborations)
NOSQL Systems 100% Verified Questions And Answers
- Course
- Institution
NOSQL Systems 100% Verified Questions And Answers...
[Show more]
Content preview
NOSQL Systems 100% Verified QuestionsAnd 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 advantages of NoSQL are. - ANS 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. - ANS True
The CAP Theorem means that. - ANS A NoSQL database can support two of
consistency, availability or partition tolerance
The BASE properties of NoSQL mean 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; it
can store both structured and unstructured data.
The key-value database Cassandra is more about availability and consistency than fault
tolerance. - ANSWER False
Cassandra as a key-value database is more advisable when. - ANSWER The application
requires more availability and fault tolerance than consistency, when the application
can give up ACID properties for performance and operational management advantages
In Cassandra as a key-value database, what are the major elements of storage? -
ANSWER Columns, super columns, families of columns and keyspace
, What does the element supercolumn consist of? - ANSWER An array of several columns
What are the components of a column family? - ANSWER Columns or grouped
super-columns that use a single, common RowKey
What are the components of a keyspace? - ANSWER Families of columns or family of
supercolumns
When comparing Cassandra with relational databases, a column is comparable to. -
ANSWER An attribute name in a table
When comparing Cassandra with relational databases, a keyspace is comparable to. -
ANSWER A relational database without interrelations
Compare Cassandra with relational databases. A column family is comparable to. -
ANSWER A tuple of a relation
State any other name of columnar database w.r.t. relational model - ANSWER Binary
relational model.
Consider two rows R1 and R2; R1(c1,c2); R2(c1,c2) in columnar database. The
columns are physically stored on disk as (a) - ANSWER The same column data values
are stored together R1c1,R2,c1, R2c1, R2,c2
Implementing an OLAP database with a relational database outperforms using a
columnar database - ANSWER False
For SAP IQ as the columnar database manager, SQL usage and support of ACID
properties are possible - ANSWER True
MongoDB saves data structures in BSON files - ANSWER True
What kind of queries does MongoDB support 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 major components of MongoDB? - ANSWER Collections, documents,
indexes
How is an objectID type formed in MongoDB? - ANSWER Within MongoDB, there is an
initial attribute that corresponds to the identifier of each document, which is kept as a
hexadecimal, and it is created by a time stamp, machine identifier, process id, and a
counter.
Name a MongoDB interactive shell that provides a way to manage server and data. -
ANSWER Mongo
What is the name of a MongoDB sentence that allows creating a collection? - ANSWER
Db.createCollection("nameof Colletion")
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 Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67163 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now