All India

NoSQL – Database Revolution Q&A

Hbase main server components include all except _
Hbase Memstore – Correect

In column-oriented stores, data is stored on a basis.
Column Family – Correct

In Hbase, ‘Columns’ are named and specified in table definition.
Fales —— Correct

HBase Tables are divided _ by row key range into .
horizontally – regions ———– Correct

Columnar databases are preferable for OLTP systems.
False – Correct

Cassandra allows to define composite Primary Keys.
True – Correct

Pre-join projection is equivalent to as in traditional relational systems.
Materialized view – Correct

In a column-database a row is being uniquely identified by __.
Row-key – Correct

In Cassandra, the _ determines how many copies of the data will be maintained across multiple nodes.
Replication factor – Correct

The column store has to perform _ IO to insert a new value.
as many disk blocks —– Correct

The row store needs to perform _ IO to insert a new value.
Single — Correct

In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation.
False —– Correct

A column-database used to store __ versions of each cells.
Multiple —– Correct


NoSQL databases are designed to expand _
horizontally — Correct

Horizontal scaling approach tends to be cheaper as the number of operations and the size of the data increases.
True — Correct

distributes different data across multiple servers.
Sharding — Correct

Limitations of RDBMS are .
Scalability/Database design complexity — Correct

Full-form of ‘CRUD’ is _.
Create-Read-Update-Delete — Correct


Key-value pair data storages include all except .
Network Attached Storage

Cassandra has properties of both and __
Google Bigtable / Amazon Dynamo

A Riak convergent replicated data type (CRDT) includes
Maps/Sets/Counters

A Key-value store does not support Secondary Indexes.
False

The RDBMS ‘table’ equivalent terminology in Riak is .
bucket


In MongoDB, there is a similar feature of ‘like’ expression as like RDBMS
False — Correct

The MATCH clause is roughly equivalent to the clause in SQL and the RETURN clause to a _ clause.
Where, Select —- Correct

__ is a syntax for retrieving specific elements from an XML document.
Xpath —- Correct

MongoDB read/write performance can be tuned with the help of Stored Procedures.
False — Correct

An RDBMS equivalent component for a “document identifier” in a Document database:
Foreign Key-value — Correct

An RDBMS equivalent component for a “document” in a Document database:
Row — Correct

Document databases split a document into its constituent name/value pairs for indexing purpose.
False —– Correct

An RDBMS equivalent component for a “collection” in a Document database:
Tables — Correct

JSON documents are built up of _.
Both the option — Correct


Only Nodes have properties in Graph database.
False — Correct

The major components of a Graph include all except _.
JSON — Correct

Cypher query language is associated with __
Neo4j — Correct

Neo4j architecture is a self-driven and independent architecture because of __
Both the options — Correct

Graph databases are generally built for use with .
OLTP — Correct


Hbase Data blocks metadata information are being maintained by _ .
NameNodes — Correct

Hbase Region assignment operation is being handled by _.
Hbase Master — Correct

In case of a Strict consistency, a read will always return the most recent data value.
True

Sorted Column store would provide higher compression ratio by representing each column as compared to the preceding one.
Delta — Correct

Some of the common Read Consistency level in Cassandra include all except __.
ONE|TWO|THREE

Some of the common Write Consistency level in Cassandra include all except _.
ONE|TWO|THREE — Wrong

The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __.
Hfile —- Wrong

_ are replicated to allow failover in MongoDB.
Shards

Read overhead in a Columnar database can be partly reduced by Multicolumn projection and _.
Sorted Column — Wrong

In Cassandra, if the replication factor is 3, the coordinator will send replicas of the data item to the next _ nodes on the ring.
2 (n-1) — Correct

Wiredtiger storage engine is a part of _.
MongoDB — Correct

Kudu can be accessed via all except _.
Mapreduce

The equivalent Hbase structure of an on-disk trees in Log-structured Merge Trees is _.
StoreTable

In case of an Eventual consistency, reads may not return the most recent value, but reads will not return values “out of sequence.”
Fales — Correct

Transactional integrity is relevant in case of batch-centric Hadoop-based analytics on warehoused data.
False — Correct

Riak demonstrates dual nature of
key/value store and a document database — Correct

Cassandra’s Gossip Protocol can take care of the heartbeat lost due to _ in a widely distributed system.
Both node failure and network issue — Correct

The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __.
Compaction — Correct

In Risk, consistency model is implemented
Eventual — Correct

Like most relational databases, Kudu also offers secondary indexes and uniqueness constraints.
False — Correct

Hbase DDL Operations (create, delete tables) are maintained by _.
Hbase Master — Correct

Cassandra lightweight transactions (LWT) supports pattern.
Compare-and-set — Correct

4 Comments

  1. Shubham kumarShubham kumar
    Shubham kumar

    Sir you are doing the fabulous job please provide the hands on….we (our group) privelezed to have people like you in world..!! If possible please try to contact sir…so that we discuss our problem of t factor with you..!!

    20 October 2020 at 10:18 am Reply
  2. gIRIgIRI
    gIRI

    A Key-value store does not support Secondary Indexes. – TRUE IS CORRECT

    15 June 2021 at 12:58 pm Reply
  3. AnonymousAnonymous
    Anonymous

    Graph databases are generally built for use with – OLAP = wrong

    1 July 2021 at 12:35 am Reply
  4. OrionOrion
    Orion

    Graph databases are generally built for use with – OLAP = wrong

    1 July 2021 at 12:36 am Reply

Leave a Reply