No SQL Quiz
1. NoSQL databases are designed to expand _________.
Answer: horizontally
2. _______ distributes different data across multiple servers.
Answer: shrading
3. Horizontal scaling approach tends to be cheaper as the number of operations and the size of the data increases.
Answer: true
4. Limitations of RDBMS are ______________.
Answer: Scalability/Database design complexity
5. Full-form of 'CRUD' is _________.
Answer: Create-Read-Update-Delete
6. A Riak convergent replicated data type (CRDT) includes ________.
Answer: Maps/Sets/Counters
7. Key-value pair data storages include all except ________.
Answer: Network Attached Storage
8. The RDBMS 'table' equivalent terminology in Riak is ________.
Answer: bucket
9. A Key-value store does not support Secondary Indexes.
Answer: False
10. Cassandra has properties of both __________ and ____________ .
Answer: Google Bigtable / Amazon Dynamo
11. In column-oriented stores, data is stored on a ____________ basis.
Answer: Column Family
12. In a column-database a row is being uniquely identified by __________.
Answer: Row-key
13. In Hbase, 'Columns' are named and specified in table definition.
Answer: False
14. HBase Tables are divided _________ by row key range into ________ .
Answer: horizontally, regions
15. In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation.
Answer: False
16. A column-database used to store __________ versions of each cells.
Answer: multiple
17. ______ is a syntax for retrieving specific elements from an XML document.
xslt(wrng) xquery(wrng)
Answer: Xpath
18. Document databases split a document into its constituent name/value pairs for indexing purpose.
Answer: False
19. MongoDB read/write performance can be tuned with the help of Stored Procedures.
Answer: False
20. The MATCH clause is roughly equivalent to the _______ clause in SQL and the RETURN clause to a ______ clause.
Answer: where
21. An RDBMS equivalent component for a "document" in a Document database:
Answer: row
22. JSON documents are built up of _________.
Answer: all
23. An RDBMS equivalent component for a "document identifier" in a Document database:
Answer: primary key
24. In MongoDB, there is a similar feature of 'like' expression as like RDBMS.
Answer: False
25. The major components of a Graph include all except _______.
Answer: JSON
26. Neo4j architecture is a self-driven and independent architecture because of ________________.
Answer: BOTH
27. Only Nodes have properties in Graph database.
Answer: False
28. Cypher query language is associated with __________.
Answer: neoj4
29. Graph databases are generally built for use with ________.
Answer: OLTP
30. Limitations of RDBMS are ______________.
Answer: scalability
31. The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __________.
Answer: compaction
32. Cassandra allows to define composite Primary Keys.
Answer: true
33. Some of the common Write Consistency level in Cassandra include all except ___________.
Answer: each
34. In case of a Strict consistency, a read will always return the most recent data value.
Answer: true
35. _________ are replicated to allow failover in MongoDB.
Answer: none
36. Cassandra's Gossip Protocol can take care of the heartbeat lost due to _______ in a widely distributed system
Answer: both
37. Kudu can be accessed via all except _________.
Answer: apache hive
38. Some of the common Write Consistency level in Cassandra include all except ___________.
Answer: each qouram
39. _________ are replicated to allow failover in MongoDB.
Answer: none
40. Wiredtiger storage engine is a part of
Answer: mongo
41. Cassandra's Gossip Protocol can take care of the heartbeat lost due to _______ in a widely distributed system.
Answer: network issue
42. Hbase Data blocks metadata information are being maintained by _________ .
Answer: namenodes
43. In a column-database, a row is being uniquely identified by __________.
Answer: Row-key
44. The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __________.
Answer: memstore
45. In Hbase, 'Columns' are named and specified in table definition.
Answer: False
46. The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __________.
Answer: compaction
47. Some of the common Read Consistency level in Cassandra include all except __________.
Answer: any
48. An RDBMS equivalent component for a "collection" in a Document database:
Answer: column
49. Read overhead in a Columnar database can be partly reduced by Multicolumn projection and
Answer: caching
50. Cassandra lightweight transactions (LWT) supports ______ pattern.
Answer: Check-and-set
51. Columnar databases are preferable for OLTP systems
Answer: True
52. Hbase Region assignment operation is being handled by _________.
Answer: ZooKeeper