InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
A Riak Convergent Replicated Data Type (CRDT) includes ________. |
|
Answer» A Riak Convergent REPLICATED Data TYPE (CRDT) includes ________. |
|
| 2. |
________ distributes different data across multiple servers. |
|
Answer» ________ distributes DIFFERENT DATA across MULTIPLE servers. |
|
| 3. |
Pre-join projection is equivalent to ________ as in traditional relational systems? |
|
Answer» PRE join PROJECTION is equivalent to ________ as in traditional RELATIONAL systems? Choose the correct OPTION from below list (1)Table (2)Materialized view (3)None of the options (4)Joins (5)Stored Procedure Answer:-(2)Materialized view |
|
| 4. |
The RDBMS "table" equivalent terminology in Riak is ________. |
|
Answer» The RDBMS "table" equivalent terminology in Riak is ________. |
|
| 5. |
The horizontal scaling approach tends to be cheaper as the number of operations, and the size of the data increases. |
|
Answer» The HORIZONTAL scaling approach tends to be CHEAPER as the number of OPERATIONS, and the size of the data increases. |
|
| 6. |
Limitation(s) of RDBMS is/are ______________. |
|
Answer» LIMITATION(s) of RDBMS is are ______________. CHOOSE the correct option from below list (1)All the OPTIONS (2)Ease of Maintenance/Performance (3)Scalability/Database DESIGN complexity (4)LESS Expensive/Performance Answer:-(3)Scalability/Database design complexity |
|
| 7. |
Which Replication model supports database read and write operations in all the nodes? |
|
Answer» Which Replication model supports database READ and write operations in all the nodes? |
|
| 8. |
The key-value pair data storages include all, except ________? |
|
Answer» The key value PAIR data storages INCLUDE all, except ________? |
|
| 9. |
Cassandra has properties of both __________ and ____________ ? |
|
Answer» Cassandra has PROPERTIES of both __________ and ____________ ? |
|
| 10. |
In RDBMS, the attributes of an entity are stored in ____________ |
|
Answer» In RDBMS, the attributes of an ENTITY are stored in ____________ |
|
| 11. |
A Key-value store supports Secondary Indexes? |
|
Answer» A KEY value store SUPPORTS Secondary Indexes? |
|
| 12. |
NoSQL databases are designed to expand _________. |
|
Answer» NoSQL databases are designed to expand _________. |
|
| 13. |
The type of scaling supported by NoSQL is ____________. |
|
Answer» The TYPE of SCALING supported by NoSQL is ____________. |
|
| 14. |
Document Store database contains data in the format of ____________. |
|
Answer» Document STORE database contains data in the FORMAT of ____________. |
|
| 15. |
Neo4j is and example of Document Store DB. |
|
Answer» Neo4j is and example of DOCUMENT Store DB. |
|
| 16. |
The syntax for retrieving specific elements from an XML document is ______________. |
|
Answer» The SYNTAX for retrieving specific elements from an XML DOCUMENT is ______________. |
|
| 17. |
All NoSQL databases are similar. |
|
Answer» All NoSQL databases are similar. |
|
| 18. |
Which type of Key-value datastore DB has its key and value sorted? |
|
Answer» Which type of Key-value datastore DB has its key and value sorted? |
|
| 19. |
NoSQL Database Revolution |
|
Answer» The SCALABILITY of the Key-Value database is achieved through Sharding. |
|
| 20. |
Which Replication model has the strongest resiliency power? |
|
Answer» Which Replication model has the STRONGEST resiliency power? |
|
| 21. |
CAP represents ____________. |
|
Answer» CAP REPRESENTS ____________. Choose the correct OPTION from below list (1)Consistency, Availability, Partition Tolerance (2)Cost free, Availability, Portability (3)None of the options Answer:-(1)Consistency, Availability, Partition Tolerance |
|
| 22. |
___________ is an Object Oriented database. |
|
Answer» ___________ is an OBJECT Oriented database. |
|
| 23. |
____________ in Key-Value databases are similar to 'Tables' in RDBMS. |
|
Answer» ____________ in Key-Value databases are similar to 'Tables' in RDBMS. |
|
| 24. |
In a Key-Value datastore, both keys and values need to be unique. |
|
Answer» In a Key-Value DATASTORE, both keys and VALUES need to be unique. |
|
| 25. |
In a columnar Database, __________ uniquely identifies a record. |
|
Answer» In a COLUMNAR Database, __________ UNIQUELY identifies a record. |
|
| 26. |
An example of Key-Value datastore is ___________. |
|
Answer» An example of Key-Value datastore is ___________. |
|
| 27. |
The Specialized Query Language(s) used in Graph datastore is/are ____________. |
|
Answer» The Specialized Query Language(s) used in Graph datastore is/are ____________. |
|
| 28. |
Which type of datastore supports nodes that are connected by relationships? |
|
Answer» Which type of datastore supports NODES that are connected by relationships? |
|
| 29. |
The syntax for retrieving specific elements from an XML document is __________. |
|
Answer» The syntax for retrieving specific ELEMENTS from an XML DOCUMENT is __________. |
|
| 30. |
Which among the following is the correct API call in Key-Value datastore? |
|
Answer» Which among the following is the correct API CALL in Key-VALUE datastore? |
|
| 31. |
The Document base unit of storage resembles __________ in an RDBMS. |
|
Answer» The DOCUMENT base UNIT of storage resembles __________ in an RDBMS. |
|
| 32. |
____________ are chunks of related data often accessed together. |
|
Answer» ____________ are CHUNKS of related DATA often accessed together. |
|
| 33. |
Which of the following factors influence(s) the choice of replication model? |
|
Answer» Which of the following factors influence(s) the choice of REPLICATION model? |
|