Hello friends in this post we are going to discuss about NO SQL Multiple choice question with answer.
1. distributes different data across multiple servers- SHarding
2.Full-form of ‘CRUD’ is .-create read update delete
3.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 . Horizontal
5.Limitations of RDBMS are ____.Scalability
6.The RDBMS ‘table’ equivalent terminology in Riak is .Bucket
7.A Key-value store does not support Secondary Indexes. –false
8.Key-value pair data storages include all except .Network
9.Cassandra has properties of both _ and ___ .Google/ama
10.A Riak convergent replicated data type (CRDT) includes .maps/sets/Counters
11.Hbase main server components include all except _.Memstore
- The column store has to perform _ IO to insert a new value. –as many disk
- 13.The row store needs to perform IO to insert a new value. – Single
- HBase Tables are divided by row key range into .Hori& Region
- Columnar databases are preferable for OLTP systems. –false
- In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation.-False
- A column-database used to store _ versions of each cells.- Multiple
- In Hbase, ‘Columns’ are named and specified in table definition. –False
- Cassandra allows to define composite Primary Keys. – True
- Pre-join projection is equivalent to as in traditional relational systems. – Materi
- In a column-database a row is being uniquely identified by _.Row key
- In column-oriented stores, data is stored on a _ basis. – Rowkey
- In Cassandra, the determines how many copies of the data will be maintained across multiple nodes.- Replication
- An RDBMS equivalent component for a “document identifier” in a Document database: -Foreign –
- MongoDB read/write performance can be tuned with the help of Stored Procedures. –False
- An RDBMS equivalent component for a “collection” in a Document database: -– table –
- JSON documents are built up of _.All the options
- Document databases split a document into its constituent name/value pairs for indexing purpose.:- False
- The MATCH clause is roughly equivalent to the _______ clause in SQL and the RETURN clause to a ______ clause. – where,select
- An RDBMS equivalent component for a “document” in a Document database: row
- ______ is a syntax for retrieving specific elements from an XML document. – Xquery
- In MongoDB, there is a similar feature of ‘like’ expression as like RDBMS. – False
- Neo4j architecture is a self-driven and independent architecture because of ________________.Both options
- Only Nodes have properties in Graph database. =False
- Graph databases are generally built for use with ________.OLTP
- The major components of a Graph include all except _______.JSON
- Cypher query language is associated with __________.Neo4J
- The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __________.WAL (not sure )
- Hbase Data blocks metadata information are being maintained by –Namenode
- Transactional integrity is relevant in case of batch-centric Hadoop-based analytics on warehoused data. – False (Not Sure )
- The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __________. –Replication(Not sure )
- 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(Not sure )
- Cassandra’s Gossip Protocol can take care of the heartbeat lost due to _______ in a widely distributed system.-Both Node and network (Not sue )
- Kudu can be accessed via all except _________.Apache Hive (not sire )
- Hbase DDL Operations (create, delete tables) are maintained by ___________.Zoo keeper (Not sure )
- Some of the common Read Consistency level in Cassandra include all except __________.One/two/three(Not Sure )
- Hbase Region assignment operation is being handled by _________.Hbase master
- Sorted Column store would provide higher compression ratio by representing each column as ________ compared to the preceding one. – ratio is wrong (Not sure )
- Read overhead in a Columnar database can be partly reduced by Multicolumn projection and _____________.Caching (Not Sure )
- Like most relational databases, Kudu also offers secondary indexes and uniqueness constraints. – True (Not Sure )
- In case of an Eventual consistency, reads may not return the most recent value, but reads will not return values “out of sequence.” – False
- Cassandra lightweight transactions (LWT) support –(compare and set)
- Riak demonstrates dual nature of _____________.-Key/value stre DB
- _________ are replicated to allow failover in MongoDB. shards
- In case of a Strict consistency, a read will always return the most recent data value. =False (Not Sure )
- Wiredtiger storage engine is a part of ___________.Mongo DB
- In Riak, ________ consistency model is implemented.- Eventual