©THESTAR EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
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
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
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
ALL RIGHTS RESERVED.
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
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
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
