Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions Network Architect Interview Questions

Top 26 CouchDB interview questions for 2020

1) What is CouchDB?

CouchDB is a document typed database server which can be accessed through RESTful JSON API. It is a schema free and Ad-hoc database with a flat address space.

2) How it is different from other databases?

  • It is not a relational database.
  • It is not a object oriented database rather it is meant to function as a seamless persistence layer for an OO programming language.

3) What language is CouchDB written in?

Early work on CouchDB was started in C++ programming language but soon replaced by Erlang OTP platform. Erlang is a functional programming language with an emphasis on fault tolerance.

4) Enlist the main features of CouchDB.

  • JSON Documents
  • RESTful Interface
  • N-Master Replication
  • Built for Offline
  • Replication filter

5) Describe CouchDB Kit.

It is designed for Python application to access and manage CouchDB. It allows to manage CouchDB server, database, doc management and view access.

6) What is ETL ?

ETL stands for Extracting, Transforming and Loading of data from any system to the destination. It consist of 3 steps for data integration process:
  • Extracting: It is the process in which first we locate the data and then removing source file.
  • Transforming: It is the process of transporting the file to the required target.
  • Loading: Loading the file in the target system in the format applicable.

7) What are the various tools used in ETL?

  • Cognos Decision Stream
  • Oracle Warehouse Builder
  • Business Objects XI
  • SAS business warehouse
  • SAS Enterprise ETL server

8) How can we distribute load across multiple nodes?

We can distribute load by using a Http proxy like nginx. Firstly, all the GET loads spread across the nodes, then it directs all the PUT, POST & DELETE to a master node.

9) What is fact? What are the types of facts?

Fact is described as a central component of a multi-dimensional model which analyse all the measures. Types of facts are:
  • Addictive Facts
  • Semi-addictive Facts
  • Non-addictive Facts

10) What is Cubes and OLAP Cubes?

Cubes are data processing unit which provides multi-dimensional analysis. It consist of fact tables and dimensions from the data warehouse. OLAP stand for Online Analytics Processing, OLAP Cubes is used for reporting purpose that stores large amount of data in multi-dimensional form.

11) What platforms does CouchDB supported?

It supports mostly all the POSIX platform such as GNU/Linux also, OS X (Apple inc.). Windows is not initially supported but now we can install in windows through two methods:
  • Installation from Binaries
  • Installation from Sources

12) Give the limitation of Views.

Views cannot update documents or database as they are always Read Only.

13) Write the syntax to obtain list of the design document?

Syntax:
startkey="_design/"&endkey="_design0"

14) Why CouchDB not use Mnesia?

It does not use due to following reasons:
  • Mnesia has storage limitation of 2 gig per file.
  • It requires validation and fixup cycle after power failure.
  • In Mnesia replication is effective for clustering but not for disconnected, distributed edits.

15) Write the code for Replication?

Syntax:
POST /_replicate with a post body of  
{"source":"$source_database"  
,  
"target":"$target_database"}

16) Enlist the location CouchDB log files.

In linux/unix default location is /usr/local/var/log/couchdb/couch.log Above set is located in default.ini file /etc/couchdb/default.ini

17) Erlang was slow in adapting Unicode.Is Unicode or UTF-8 a problem with CouchDB?

CouchDB uses Erlang binaries internally.All data coming to CouchDB must be UTF-8 encoded.

18) What does IBM’s involvement mean for CouchDB and the community?

The main consequences of IBM’s involvement are:
  • The code is now being apache licensed, instead of GPL.
  • Damien is going to be contributing much more time.

19) What is the use of CouchDB?

CouchDB allows you to write a client side application that connect directly to the Couch without the need for a server side middle layer. It also reduces development time.

20) What does COUCH means in CouchDB?

It's an acronym,Cluster of Unreliable Commodity Hardware. It's acronym defines the goals of massive scalability and high reliability on fault-prone hardware.

21) How is PouchDB different from CouchDB?

PouchDB is a CouchDB client, due to which we can easily switch between a local database or an online CouchDB instance without changing any of the application’s code. Some of the differences are:
  • View Collation:CouchDB uses ICU to order keys in a view query whereas in PouchDB keys are in ASCII ordered.
  • View Offset:CouchDB returns an offset property in the view results. In PouchDB, offset just mirrors the skip parameter rather than returning a true offset.

22) How to use transactions with CouchDB?

CouchDB uses an “Optimistic concurrency” model. This model allows to send a document version along with the update, and CouchDB rejects the change if the current document version doesn’t match with the sent document.

23) Enlist basics of CouchDB?

  • All the Items stored in the database is documents.
  • Each documents has units called, fields , and fields are key and value pair.
  • Each document has an unique id to identify them "_id" being the key and the value of each document must be unique.
  • Database operations are done through REST Style http requests.
  • CouchDb's responses are in JSON format etc.

24) How can we connect to CouchDB without going through the HTTP API?

CouchDB’s data model and internal API map the REST/HTTP model so well that any other API would basically similar to HTTP.

25) How can we connect to remote CouchDB?

On the local machine,set up an ssh tunnel to your server and tell it to forward requests to the local port 5984 to the remote server's port 5984:
$ ssh -L5984:127.0.0.1:5984 ssh.example.com
Now we can connect to the remote CouchDB through localhost:5984/

26) Enlist different HTTP request format.

  • GET
  • POST
  • HEAD
  • PUT
  • DELETE
  • COPY