0% found this document useful (0 votes)
89 views4 pages

No SQL

The document discusses key-value stores, column-oriented databases, document databases, and graph databases. It provides questions to test knowledge about these NoSQL database types and their properties. Correct answers are provided after each question. Key topics covered include horizontal scaling, CRUD operations, data models like rows and columns, and components of databases like Cassandra, HBase, MongoDB, and Neo4j.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
89 views4 pages

No SQL

The document discusses key-value stores, column-oriented databases, document databases, and graph databases. It provides questions to test knowledge about these NoSQL database types and their properties. Correct answers are provided after each question. Key topics covered include horizontal scaling, CRUD operations, data models like rows and columns, and components of databases like Cassandra, HBase, MongoDB, and Neo4j.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 4

distributes different data across multiple servers.

Sharding--correct

Limitations of RDBMS are

Scalability/Database design complexity--correct

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

True--correct

NoSQL databases are designed to expand _.

horizontally--correct

Full-form of 'CRUD' is _.

Create-Read-Update-Delete--correct

A Riak convergent replicated data type (CRDT) includes .

Maps/Sets/Counters--correct

Cassandra has properties of both and __ .

Google Bigtable / Amazon Dynamo--correct

A Key-value store does not support Secondary Indexes.

False--correct

The RDBMS 'table' equivalent terminology in Riak is .

bucket--correct

Key-value pair data storages include all except .

Network Attached Storage--correct

The column store has to perform _ IO to insert a new value.

as many disk blocks--correct

In Hbase, 'Columns' are named and specified in table definition.

False--correct

In Cassandra, the ___ determines how many copies of the data will be maintained
across multiple nodes.

Replication factor--correct

A column-database used to store __ versions of each cells.


Multiple--correct

HBase Tables are divided _ by row key range into .

horizontally, regions--correct

Hbase main server components include all except _.

Hbase Memstore--correct

Cassandra allows to define composite Primary Keys.

True--correct

Columnar databases are preferable for OLTP systems.

False--correct

In column-oriented stores, data is stored on a basis.

Column Family--correct

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

False--correct

In a column-database a row is being uniquely identified by __.

Row-key--correct

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

Single--correct

Pre-join projection is equivalent to as in traditional relational systems.

Materialized view--correct

The MATCH clause is roughly equivalent to the clause in SQL and the RETURN clause
to a _ clause.

Where, Select--correct

An RDBMS equivalent component for a "document identifier" in a Document database:

Foreign Key--correct

JSON documents are built up of _.

All the options--correct


______ is a syntax for retrieving specific elements from an XML document.

Xpath--correct

An RDBMS equivalent component for a "document" in a Document database:

Row--correct

In MongoDB, there is a similar feature of 'like' expression as like RDBMS.

False--correct

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

False--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:

Table--correct

Cypher query language is associated with __.

Neo4j--correct

Graph databases are generally built for use with .

OLTP--correct

Neo4j architecture is a self-driven and independent architecture because of __.

Both the options--correct

The major components of a Graph include all except _.

JSON--correct

Only Nodes have properties in Graph database.

False--correct

Some of the common Write Consistency level in Cassandra include all except ___.

All the options--wrong

Hbase Region assignment operation is being handled by

Hbase Master--correct

In Cassandra, if the replication factor is 3, the coordinator will send replicas of


the data item to the next _ nodes on the ring.

4--wrong
Transactional integrity is relevant in case of batch-centric Hadoop-based analytics
on warehoused data.

False--correct

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

Delta--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

You might also like