NOSQL Systems 100% Verified Questions
And 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")
And 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")
