Confuse Skull: NoSQL - Database Revolution MCQ's

NoSQL - Database Revolution MCQ's

1. Hbase main server components include all except _

Hbase Memstore

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

Column Family

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

False

4. HBase Tables are divided _ by row key range into .

horizontally - regions

5. Columnar databases are preferable for OLTP systems.

False

6. Cassandra allows to define composite Primary Keys.

True

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

Materialized view

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

Row-key

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

Replication factor

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

as many disk blocks

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

Single

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

False

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

Multiple

14. NoSQL databases are designed to expand _

horizontally

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

True

16. distributes different data across multiple servers.

Sharding

17. Limitations of RDBMS are .

Scalability/Database design complexity

18. Full-form of 'CRUD' is _.

Create-Read-Update-Delete

19. Key-value pair data storages include all except .

Network Attached Storage

20. Cassandra has properties of both and __

Google Bigtable / Amazon Dynamo

21. A Riak convergent replicated data type (CRDT) includes

Maps/Sets/Counters

22. A Key-value store does not support Secondary Indexes.

False

23. The RDBMS 'table' equivalent terminology in Riak is .

bucket

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

False

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

Where, Select

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

Xpath

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

False

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

Foreign Key-value

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

Row

30. Document databases split a document into its constituent name/value pairs for indexing purpose.

False

31. An RDBMS equivalent component for a "collection" in a Document database:

Tables

32. JSON documents are built up of _.

Both the option

33. Only Nodes have properties in Graph database.

False

34. The major components of a Graph include all except _.

JSON

35. Cypher query language is associated with __

Neo4j

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

Both the options

37. Graph databases are generally built for use with .

OLTP

38. Hbase Data blocks metadata information are being maintained by _ .

NameNodes

39. Hbase Region assignment operation is being handled by _.

Hbase Master

40. In case of a Strict consistency, a read will always return the most recent data value.

True

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

Delta

42. Some of the common Read Consistency level in Cassandra include all except __.

ONE|TWO|THREE

43. _ are replicated to allow failover in MongoDB.

Shards

44. In Cassandra, if the replication factor is 3, the coordinator will send replicas of the data item to the next _ nodes on the ring.

2 (n-1)

45. Wiredtiger storage engine is a part of ___.

MongoDB

46. Kudu can be accessed via all except _.

Mapreduce

47. The equivalent Hbase structure of an on-disk trees in Log-structured Merge Trees is ___.

StoreTable

48. In case of an Eventual consistency, reads may not return the most recent value, but reads will not return values “out of sequence.”

False

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

False

50. Riak demonstrates dual nature of

key/value store and a document database

51. Cassandra's Gossip Protocol can take care of the heartbeat lost due to _ in a widely distributed system.

Both node failure and network issue

52. The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __.

Compaction

53. In Riak, consistency model is implemented

Eventual

54. Like most relational databases, Kudu also offers secondary indexes and uniqueness constraints.

False

55. Hbase DDL Operations (create, delete tables) are maintained by ___.

Hbase Master

56. Cassandra lightweight transactions (LWT) supports pattern.

Compare-and-set

No comments:

Post a Comment