Confuse Skull: Structured Query Language(SQL) MCQ's

Structured Query Language(SQL) MCQ's

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

Region Server

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

Materialized view

3. Hbase main server components include all except

Hbase Memstore

4. The column store has to perform _____ IO to insert a new value.

multiple

5. The row store needs to perform _____ IO to insert a new value.

single

6. NoSQL databases are designed to expand _________.

horizontally

7. _______ distributes different data across multiple servers.

shrading

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

tr

9. Limitations of RDBMS are ______________.

Scalability/Database design complexity

10. Full-form of 'CRUD' is _________.

Create-Read-Update-Delete

11. A Riak convergent replicated data type (CRDT) includes ________.

Maps/Sets/Counters

12. Key-value pair data storages include all except ________.

Network Attached Storage

13. The RDBMS 'table' equivalent terminology in Riak is ________.

bucket

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

False

15. Cassandra has properties of both and __ .

Google Bigtable / Amazon Dynamo

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

Column Family

17. In a column-database a row is being uniquely identified by __________.

Row-key

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

False

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

horizontally, regions

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

False

21. A column-database used to store __________ versions of each cells.

multiple

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

Xpath

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

False

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

False

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

where

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

row

27. JSON documents are built up of _________.

all

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

False

29. The major components of a Graph include all except _______.

JSON

30. Neo4j architecture is a self-driven and independent architecture because of ________________.

BOTH

31. Only Nodes have properties in Graph database.

False

32. Cypher query language is associated with __________.

neoj4

33. Graph databases are generally built for use with ________.

OLTP

34. Limitations of RDBMS are ______________.

scalability

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

compaction

36. Cassandra allows to define composite Primary Keys.

True

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

True

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

both

39. Kudu can be accessed via all except _________.

apache hive

40. Some of the common Write Consistency level in Cassandra include all except ___________.

each qouram

41. _________ are replicated to allow failover in MongoDB.

none

42. Wiredtiger storage engine is a part of

mongo

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

network issue

44. Hbase Data blocks metadata information are being maintained by _________ .

namenodes

45. In a column-database, a row is being uniquely identified by __________.

Row-key

46. The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __________.

memstore

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

False

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

compaction

49. Some of the common Read Consistency level in Cassandra include all except __________.

any

50. Read overhead in a Columnar database can be partly reduced by Multicolumn projection and

caching

51. Cassandra lightweight transactions (LWT) supports ______ pattern.

Check-and-set

52. Columnar databases are preferable for OLTP systems

True

53. Hbase Region assignment operation is being handled by _________.

ZooKeeper

No comments:

Post a Comment