NoSQL - Database Revolution
Fresco Play MCQs Hands on Answers
All Question of the Quiz
Present Below for Ease Use Ctrl + F to
find the Question.
NoSQL Basics
1.The full form of 'CRUD'
is _________.
Create-Read-Update-Delete
2.________ distributes
different data across multiple servers.
Sharding
3.The horizontal scaling
approach tends to be cheaper as the number of operations, and the size of the
data increases.
True
4.NoSQL databases are
designed to expand _________.
Horizontally
5.Limitation(s) of RDBMS
is/are ______________.
Scalability/Database design complexity
Quiz on NoSQL: Key-Value Store
1.The key-value pair data
storages include all, except ________.
Network Attached Storage
2.Cassandra has properties
of both __________ and ____________ .
Google Bigtable / Amazon Dynamo
3.A Riak Convergent
Replicated Data Type (CRDT) includes ________.
Maps/Sets/Counters
4.The RDBMS 'table'
equivalent terminology in Riak is ________.
Bucket
5.A Key-value store
supports Secondary Indexes.
True
Quiz on NoSQL: Columnar Store
1.Pre-join projection is
equivalent to ________ as in traditional relational systems.
Materialized view
2.The column store has to
perform _______ IO to insert a new value.
as many disk blocks
3.In column-oriented
stores, data is stored on a ____________ basis.
Column Family
4.HBase tables are divided
_________ by row key range into ________ .
horizontally, regions
5.The row store needs to
perform _______ IO to insert a new value.
Single
6.HBase main server
components include all except _________.
HBase Memstore
7.In a columnar database,
the columns are stored together on disk, achieving a higher compression ratio,
which is an expensive operation.
False
8.Columnar databases are
preferable for OLTP systems.
False
9.In HBase, 'Columns' are
named and specified in the table definition.
False
10.In a column-database, a
row is uniquely identified by __________.
Row-key
11.In Cassandra, the
_________ determines how many copies of the data will be maintained across
multiple nodes.
Replication factor
12.A column-database is
used to store ________ versions of each cell.
Multiple
13.The column store has to
perform _______ IO to insert a new value.
as many disk blocks
Quiz on NoSQL: Document Store
1.JSON documents are built
up of _________.
All the options
2.An RDBMS equivalent
component for a document in a document database is ___________.
Row
3.______ is the syntax for
retrieving specific elements from an XML document.
XPath
4.MongoDB read/write
performance can be tuned with the help of Stored Procedures.
False
5.An RDBMS equivalent
component for a document identifier in a document database is ________.
Foreign Key
6.In MongoDB, there is a
similar feature of 'like' expression similar to that in RDBMS.
False
7.Document databases split
a document into its constituent name/value pairs for indexing purposes.
False
8.An RDBMS equivalent
component for a collection in a document database is ___________.
Table
9.The MATCH clause is
roughly equivalent to the _______ clause in SQL and the RETURN clause to a
______ clause.
Where, Select
Quiz on NoSQL: Graph Store
1.Graph databases are
generally built for use with ________.
OLTP
2.Neo4j architecture is a
self-driven and independent architecture because of ________________.
Both the options
3.Only Nodes have
properties in the Graph database.
False
4.Cypher query language is
associated with __________.
Neo4j
5.The major components of a
graph include the following, except _______.
JSON
NoSQL Final Assessment
1.Terrastore is an example
of __________.
Document datastore
2.__________ is a Columnar
database that runs on a Hadoop cluster.
Apache HBase
3.In Riak Key Value
datastore, the Replication Factor 'N' indicates __________.
Number of Data Copies to be maintained across nodes
4.The scalability of
Key-Value database is achieved through __________.
Sharding Replication
5.__________ in Key-Value
Databases are similar to 'Tables' in RDBMS.
Buckets
6.Columnar datastore avoids
storing null values.
True
7.The Specialized Query
Language(s) used in Graph datastore is/are __________.
All the options
8.Cassandra was developed
by __________
Facebook
9.In Riak Key Value
datastore, the variable 'W' indicates __________.
Number of Data Copies to be maintained across nodes
10.The type of Graph Store
that works in real-time is __________.
All the options
11.The syntax for
retrieving specific elements from an XML document is __________.
XPath
12.Which Replication model
has the strongest resiliency power?
Peer to Peer Replication Model
13.The famous XML
Database(s) is/are _________.
eXist and MarkLogic
14.Which type of scaling
handles voluminous data by adding servers to the clusters?
Horizontal
15.Apache Kudu distributes
data through Vertical Partitioning.
False
16.NoSQL can handle
__________.
Unstructured and Semi-structured data
17.Which type of datastore
supports nodes that are connected by relationships?
Graph datastore
18.Which type of database
requires a trained workforce for the management of data?
RDBMS
19.Hash Table Design is
similar to __________.
Key Value datastore
20.__________ requires data
in a structured format as per the defined data model.
RDBMS
21.The most popular
Navigational DBMS system is/are __________.
Integrated Management System and Integrated Database
System
22.Which of the following
does not have restrictions on the data type it stores?
Columnar Family in Columnar Datastore
23.Example(s) of Columnar
Database is/are __________.
Cassandra and HBase
24.In a Column Data Model,
the number of columns that a row can have __________.
Varies
25.In the Master-Slave Replication
model, the slave node services __________.
Read operations
26.The Property Graph Model
is similar to __________.
Entity Relationship Diagram
27.The file format(s) that
can be stored and retrieved from the Document Store NoSQL data model is/are
__________.
All the options
28.Which Replication model
supports database read and write operations in all the nodes?
Peer to Peer Replication Model
29.Riak DB leverages the
CAP Theorem to improve its scalability.
True
30.In the Master-Slave
Replication model, the node which pushes all the updates in data to subordinate
nodes is __________.
Master Node
31.The language to
transform XML documents into other formats, like non-XML formats such as HTML
is _________.
XSLT
32.NoSQL is a Relational
Data Model.
False
33.In the Master-Slave
Replication model, different Slave Nodes contain __________.
Same data
34.The key parameter(s) to
be taken into consideration while weighing NoSQL databases against each other
is/are __________
All the options
35.Which among the
following is the correct API call in Key-Value datastore?
put(key,value)
36.Which type of Key-Value
datastore DB has its key and value sorted?
Ordered Key-Value datastore
37.An expressive structure
with the collection of nodes and relationships interlinking them is __________.
Graph datastore
38.Which among the
following is used by Amazon to store the user's shopping cart details?
DynamoDB
39.NoSQL data replication
is __________.
Homogenous
40.All NoSQL databases are
similar.
False
41.Which of the following
has properties attached to it in the Graph datastore?
Nodes and Relationships
42.The Document base unit
of storage resembles __________ in an RDBMS.
Rows
43.The core principle of
NoSQL is __________.
BASE
44.__________ are chunks of
related data often accessed together.
Column Families
45.In a columnar Database,
__________ uniquely identifies a record.
Row-Key
46.Relational Database
satisfies __________.
All the options
47.CAP represents
__________.
Consistency, Availability, Partition Tolerance
48.__________ is an Object
Oriented Database.
NoSQL
49.In a Key-Value
datastore, both keys and values need to be unique.
False
50.Which of the following
factors influence(s) the choice of replication model?
All the options
51.Document Store database
contains data in the format of __________.
All the options
0 Comments