Disclaimer: The main motive to provide this solution is to help and support those who are unable to do these courses due to facing some issue and having a little bit lack of knowledge. All of the material and information contained on this website is for knowledge and education purposes only.
Yours Shah Rukh
NoSQL Basics
1.The complete shape of 'CRUD' is _________.
Create-Read-Update-Define
None of the options
Create-Read-Update-Deliver
Create-Run-Update-Delete
Create-Read-Update-Delete
Answer: 5)Create-Read-Update-Delete
2.________ distributes distinct facts throughout more than one servers.
None of the options
Bucketing
Sharding
Partitioning
Answer: 3)Sharding
3.The horizontal scaling technique has a tendency to be inexpensive because the range of operations, and the scale of the facts increases.
True
False
Answer: 1)True
4.NoSQL databases are designed to extend _________.
with growth of load
vertically
hardware wise
horizontally
Answer: 4)horizontally
5.Limitation(s) of RDBMS is/are ______________.
All the options
Ease of Maintenance/Performance
Scalability/Database layout complexity
Less Expensive/Performance
Answer: 3)Scalability/Database layout complexity
Quiz on NoSQL: Key-Value Store
1.The key-price pair facts storages consist of all, besides ________.
In-memory
Network Attached Storage
Disk Storage
Cache Storage
All the options
Answer: 2)Network Attached Storage
2.Cassandra has homes of each __________ and ____________ .
Kudu and Hbase
Neo4j / Amazon Dynamo
All the options
Google Bigtable / Amazon Dynamo
MongoDB / Google BigTable
Answer: 4)Google Bigtable / Amazon Dynamo
3.A Riak Convergent Replicated Data Type (CRDT) consists of ________.
All the options
JSON/Maps/Sets
JSON/Maps
Maps/Sets/Counters
Sets
Answer: 4)Maps/Sets/Counters
4.The RDBMS 'desk' equal terminology in Riak is ________.
facts shop
None of the options
facts segment
bucket
key-price
Answer: 4)bucket
5.A Key-price shop helps Secondary Indexes.
False
True
Answer: 2)True
Quiz on NoSQL: Columnar Store
1.Pre-be a part of projection is equal to ________ as in conventional relational systems.
Table
Materialized view
None of the options
Joins
Stored Procedure
Answer: 2)Materialized view
2.The column shop has to carry out _______ IO to insert a brand new price.
Single
as many disk blocks
Two
None of the options
Multiple
Answer: 2)as many disk blocks
3.In column-orientated stores, facts is saved on a ____________ basis.
Column
Column Family
Row Key
Answer: 2)Column Family
4.HBase tables are divided _________ with the aid of using row key variety into ________ .
vertically, location servers
horizontally, location servers
vertically, regions
horizontally, regions
horizontally, HDFS Files
Answer: 4)horizontally, regions
5.The row shop wishes to carry out _______ IO to insert a brand new price.
None of the options
Two
Multiple
As many disk blocks as there are columns
Single
Answer: 5)Single
6.HBase predominant server additives consist of all besides _________.
HBase HFile
HBase Master
All the options
HBase Memstore
Region Server
ZooKeeper
Answer: 4)HBase Memstore
7.In a columnar database, the columns are saved collectively on disk, reaching a better compression ratio, that is an steeply-priced operation.
False
True
Answer: 1)False
8.Columnar databases are top-rated for OLTP systems.
False
True
Answer: 1)False
9.In HBase, 'Columns' are named and particular withinside the desk definition.
True
False
Answer: 2)False
10.In a column-database, a row is uniquely recognized with the aid of using __________.
Column-identifier
None of the options
Row-key
Column-family
Answer: 3)Row-key
11.In Cassandra, the _________ determines what number of copies of the facts might be maintained throughout more than one nodes.
Read Consistency
None of the options
Replication factor
Write Consistency
Answer: 3)Replication factor
12.A column-database is used to shop ________ variations of every cell.
Two
Latest
Single
None of the options
Multiple
Answer: 5)Multiple
13.The column shop has to carry out _______ IO to insert a brand new price.
Multiple
as many disk blocks
None of the options
Single
Two
Answer: 2)as many disk blocks
Quiz on NoSQL: Document Store
1.JSON files are constructed up of _________.
arrays
objects
All the options
values
Answer: 3)All the options
2.An RDBMS equal aspect for a record in a record database is ___________.
Column
Row
Primary Key
Table
None of the options
Answer: 2)Row
3.______ is the syntax for retrieving unique factors from an XML record.
XPath
None of the options
XQuery
XSLT
Answer: 1)XPath
4.MongoDB examine/write overall performance may be tuned with the assist of Stored Procedures.
False
True
Answer: 1)False
5.An RDBMS equal aspect for a record identifier in a record database is ________.
Foreign Key
Table
None of the options
Column
Primary Key
Answer: 1)Foreign Key
6.In MongoDB, there may be a comparable characteristic of 'like' expression much like that during RDBMS.
True
False
Answer: 2)False
7.Document databases cut up a record into its constituent name/price pairs for indexing purposes.
True
False
Answer: 2)False
8.An RDBMS equal aspect for a set in a record database is ___________.
None of the options
Table
Primary Key
Column
Row
Answer: 2)Table
9.The MATCH clause is kind of equal to the _______ clause in SQL and the RETURN clause to a ______ clause.
In, From
In, Select
None of the options
Where, Select
Between, Select
Answer: 4)Where, Select
Quiz on NoSQL: Graph Store
1.Graph databases are commonly constructed to be used with ________.
Data Warehouse Batch Processing
OLTP
OLAP
All the options
Answer: 2)OLTP
2.Neo4j structure is a self-pushed and unbiased structure due to ________________.
Both the options
Cluster Manager vehiclemobile sync-up functionality
Neo4j database times vehiclemobile sync-up functionality
Answer: 1)Both the options
3.Only Nodes have homes withinside the Graph database.
False
True
Answer: 1)False
4.Cypher question language is related to __________.
None of the options
MongoDB
Sybase
Cassandra
Neo4j
Answer: 5)Neo4j
5.The principal additives of a graph consist of the subsequent, besides _______.
All the options
Properties
JSON
None of the options
Nodes
Relationships
Answer: 3)JSON
NoSQL Final Assessment
1.Terrastore is an instance of __________.
Document datastore
Columnar datastore
Graph datastore
Key Value datastore
Answer: 1)Document datastore
2.__________ is a Columnar database that runs on a Hadoop cluster.
Redis
Apache HBase
None of the options
Cassandra
Answer: 2)Apache HBase
3.In Riak Key Value datastore, the Replication Factor 'N' shows __________.
Number of Write Operations
Number of Data Copies to be maintained throughout nodes
Answer: 2)Number of Data Copies to be maintained throughout nodes
4.The scalability of Key-Value database is performed via __________.
Peer to Peer Replication
Master-Slave Replication
Sharding Replication
Answer: 3)Sharding Replication
5.__________ in Key-Value Databases are much like 'Tables' in RDBMS.
Keys
Values
None of the options
Buckets
Answer: 4)Buckets
6.Columnar datastore avoids storing null values.
True
False
Answer: 1)True
7.The Specialized Query Language(s) utilized in Graph datastore is/are __________.
Cypher
None of the options
Gremlin
All the options
Answer: 1)All the options
8.Cassandra turned into evolved with the aid of using __________
None of the options
Amazon
Answer: 1)Facebook
9.In Riak Key Value datastore, the variable 'W' shows __________.
Number of Data Copies to be maintained throughout nodes
Number of Write Operations
Answer: 1)Number of Data Copies to be maintained throughout nodes
10.The kind of Graph Store that works in real-time is __________.
None of the options
All the options
Graph Compute Engine
Graph Database
Answer: 2)All the options
11.The syntax for retrieving unique factors from an XML record is __________.
XMLSchema
XQuery
XPath
Answer: 3)XPath
12.Which Replication version has the most powerful resiliency power?
Sharding Replication Model
All the options
Master-Slave Replication Model
Peer to Peer Replication Model
Answer: 2)Peer to Peer Replication Model
13.The well-known XML Database(s) is/are _________.
eXist
MarkLogic
eXist, MarkLogic and Cassandra
Cassandra
eXist and MarkLogic
Answer: 5)eXist and MarkLogic
14.Which kind of scaling handles voluminous facts with the aid of using including servers to the clusters?
Horizontal
Vertical
Answer: 1)Horizontal
15.Apache Kudu distributes facts via Vertical Partitioning.
False
True
Answer: 1)False
16.NoSQL can manage __________.
Unstructured and Semi-dependent facts
None of the options
Semi-dependent facts only
Unstructured Data only
Answer: 1)Unstructured and Semi-dependent facts
17.Which kind of datastore helps nodes which might be related with the aid of using relationships?
Key Value datastore
Columnar datastore
Document datastore
Graph datastore
Answer: 4)Graph datastore
18.Which kind of database calls for a skilled team of workers for the control of facts?
NoSQL
RDBMS
Answer: 2)RDBMS
19.Hash Table Design is much like __________.
Document datastore
Key Value datastore
Columnar datastore
Graph datastore
Answer: 2)Key Value datastore
20.__________ calls for facts in a dependent layout as in keeping with the described facts version.
RDBMS
NoSQL
Answer: 1)RDBMS
21.The maximum famous Navigational DBMS gadget is/are __________.
Integrated Management System and Integrated Database System
None of the options
Integrated Management System
Integrated Database System
Answer: 1)Integrated Management System and Integrated Database System
22.Which of the subsequent does now no longer have regulations at the facts kind it stores?
All the options
Columnar Family in Columnar Datastore
Columns in RDBMS
None of the options
Answer: 1)Columnar Family in Columnar Datastore
23.Example(s) of Columnar Database is/are __________.
Cassandra and HBase
Cassandra, HBase and Redis
Cassandra
HBase
Redis
Answer: 1)Cassandra and HBase
24.In a Column Data Model, the range of columns that a row will have __________.
stays the same
varies
Answer: 2)varies
25.In the Master-Slave Replication version, the slave node offerings __________.
None of the options
Write operations
Read operations
Read and Write operations
Answer: 3)Read operations
26.The Property Graph Model is much like __________.
Entity Relationship Diagram
None of the options
Use Case Diagram
Sequence Diagram
Answer: 1)Entity Relationship Diagram
27.The document layout(s) that may be saved and retrieved from the Document Store NoSQL facts version is/are __________.
XML
JSON
BSON
All the options
Answer: 4)All the options
28.Which Replication version helps database examine and write operations in all of the nodes?
Master-Slave Replication
All the options
None of the options
Peer to Peer Replication Model
Answer: 4)Peer to Peer Replication Model
29.Riak DB leverages the CAP Theorem to enhance its scalability.
True
False
Answer: 1)True
30.In the Master-Slave Replication version, the node which pushes all of the updates in facts to subordinate nodes is __________.
Slave Node
All the options
Master Node
Answer: 3)Master Node
31.The language to convert XML files into different codecs, like non-XML codecs including HTML is _________.
XPath
XSLT
XQuery
XML
Answer: 2)XSLT
32.NoSQL is a Relational Data Model.
False
True
Answer: 1)False
33.In the Master-Slave Replication version, distinct Slave Nodes incorporate __________.
Different facts
Same facts
Answer: 2)Same facts
34.The key parameter(s) to be considered even as weighing NoSQL databases towards every different is/are __________
Performance
Database Features
Context-primarily based totally Criteria
All the options
Answer: 4)All the options
35.Which the various following is the proper API name in Key-Value datastore?
put(key,price)
put(key)
put(price)
None of the options
Answer: 1)put(key,price)
36.Which kind of Key-Value datastore DB has its key and price sorted?
Solid-State Key-Value datastore
RAM Key-Value datastore
Ordered Key-Value datastore
Eventually Consistent Key-Value datastore
Answer: 3)Ordered Key-Value datastore
37.An expressive shape with the gathering of nodes and relationships interlinking them is __________.
Graph datastore
Key-Value datastore
Columnar datastore
Answer: 1)Graph datastore
38.Which the various following is utilized by Amazon to shop the user's purchasing cart details?
MemCached
Riak
Redis
DynamoDB
Answer: 4)DynamoDB
39.NoSQL facts replication is __________.
Heterogenous
Homogenous
Answer: 2)Homogenous
40.All NoSQL databases are comparable.
True
False
Answer: 2)False
41.Which of the subsequent has homes connected to it withinside the Graph datastore?
None of the options
Nodes
Nodes and Relationships
Relationships
Answer: 3)Nodes and Relationships
42.The Document base unit of garage resembles __________ in an RDBMS.
Columns
Rows
Answer: 2)Rows
43.The middle precept of NoSQL is __________.
None of the options
ACID
BASE
Answer: 3)BASE
44.__________ are chunks of associated facts frequently accessed collectively.
All the options
Columns
Documents
Column Families
Answer: 4)Column Families
45.In a columnar Database, __________ uniquely identifies a record.
None of the options
All the options
Column-Key
Row-Key
Answer: 4)Row-Key
46.Relational Database satisfies __________.
ACID Properties
All the options
BASE Properties
Answer: 2)All the options
47.CAP represents __________.
Consistency, Availability, Partition Tolerance
None of the options
Cost free, Availability, Portability
Answer: 1)Consistency, Availability, Partition Tolerance
48.__________ is an Object Oriented Database.
NoSQL
RDBMS
Answer: 1)NoSQL
49.In a Key-Value datastore, each keys and values want to be unique.
True
False
Answer: 2)False
50.Which of the subsequent elements influence(s) the selection of replication version?
Environment
All the options
Server Capacity
Application Demand
Throughput
Answer: 2)All the options
51.Document Store database incorporates facts withinside the layout of __________.
All the options
XML record
BSON record
JSON record
Answer: 1)All the options
0 Comments