Explore topic-wise InterviewSolutions in .

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.

Mention the location of log files in CouchDB?

Answer»
  • In Linux or UNIX log files are located in /usr/local/var/log/CouchDB/couch.log . This log FILE location can be SET in the default.ini file.default.ini file is located in /etc/CouchDB/path.
  • If the user has installed from the SOURCE and the user is RUNNING the CouchDB in the dev mode, then the location of the log files will be:- YOUR_CouchDB_SOURCE_DIRECTORY/tmp/log/couch.log
Discussion
2.

What is fact and explain its types?

Answer»

FACT is represented as a vital component of a multi-dimensional model which EXAMINE all the measures.

There are FOUR types of Facts:-
  • ADDICTIVE Facts
  • Semi-addictive Facts
  • Non-addictive Facts
Discussion
3.

Explain the various tools used in ETL?

Answer»

The TOOLS that are used in ETL ( Extracting, TRANSFORMING and LOADING )are:-

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

What do you mean by ETL?

Answer»

ETL represents Extracting, Transforming and Loading of the data from any of the systems to the destination. ETL includes 3 steps for the data integration process:

  • Extracting: In the method of Extracting the data is FIRST located and then the source file is removed.
  • Transforming: In the process of Transforming the file is transported to the REQUIRED target
  • Loading: In the process of loading the data is charged in the target SYSTEM in the appropriate format.

This is ONE of the favorite questions in COUCHDB interview Questions.
Discussion
5.

Explain the difference between SQL and CouchDB?

Answer»
S.noSQLCouchDB
1.SQL STORES the data by USING RDBMSCouchDB stores the data in the JSON document.
2.SQL PREFER an AUTOMATIC transmissionCouchDB prefers a manual transmission
3.SQL is written in C, C++CouchDB is written in ERLANG
Discussion
6.

How to use transactions with CouchDB?

Answer»

CouchDB makes the use of a MODEL which is known as an ‘Optimistic Currency’ model. ‘Optimistic Currency’ model grants approval to send a DOCUMENT VERSION with the CouchDB update. CouchDB scans the document version, and if the PRESENT document version does not TALLY with document version which was was sent, then CouchDB rejects the change in the release.
Discussion
7.

What do you mean by CouchdbKit?

Answer»

CouchDBkit is a complete package which gives full-featured and easy client framework to the PYTHON applications to access and manage CouchDB. CouchDBkit assists in maintaining the databases, CouchDB server, view access, and DOC management.

Point to be noted: GO through this Q&A very thoroughly as this is one of the essential CouchDB INTERVIEW QUESTIONS.
Discussion
8.

Please explain the main features of CouchDB?

Answer»
  • Stores the data in the JSON document.
  • It does all the work such as data INSERTION, replication, etc. via HTTP, so it has a RESTful interface
  • It can replicate to those devices that go offline and then take CARE of the data sync when they come online like ANDROID Phones
  • It assists the user in filtering out the data that a user wants to replicate to the different nodes.
  • Unlimited amount of ‘MASTERS’ can be used, i.e., in CouchDB, there is multi-master replication
Discussion
9.

Explain the difference between PouchDB and CouchDB?

Answer»
S.noPouchDBCouchDB
1.In PouchDB Keys are ASCII orderedCouchDB makes use of ICU to ORDER the keys in a view query
2.In the view results, the actual offset is not returned SOMEWHAT offset only mirrors the skip parameterIn the view results, CouchDB returns an offset property

This is one of the most asked CouchDB INTERVIEW questions.
Discussion
10.

Please explain couchdb vs mongodb?

Answer»
S.noCOUCHDBMONGODB
1.In CouchDB, the records are stored in the DOCUMENTS in the database.In MongoDB, the records are stored in the collection in the database
2.Master-Master replication in CouchDBMaster-Slave replication in MongoDB
3.CouchDB is WRITTEN in ErlangMongoDB is written in C++
4.In CouchDB, the INTERFACE is REST/HTTPIn MongoDB, the interface is TCP/IP Custom Protocol
5.Slower than MongoDBFaster than CouchDB
Discussion
11.

What is the difference between CouchDB and RDBMS?

Answer»
S.noCouchDBRDBMS
1.Data is STORED in documents in CouchDBData is stored in tables in RDBMS
2.Replication is EASY in CouchDBReplication is DIFFICULT in RDBMS
Discussion
12.

Explain the advantages of CouchDB?

Answer»

Some of the advantages of COUCHDB are:-

  • Multi-Version Concurrency CONTROL (MVCC) Support
  • Incremental Replication
  • Availability
  • Partition Tolerance
  • Browser Based GUI
  • ACID Properties

This is a FUNDAMENTAL CouchDB interview question
Discussion
13.

What is CouchDB and why it is used?

Answer»

The couch is an acronym for Cluster Of Unreliable Commodity HARDWARE and DB for the database. CouchDB is an open source software. Its a complete focus is on the EASE of use and embracing the web.CouchDB has a No SQL document-oriented database architecture. CouchDB is written in ERLANG language.

Why is CouchDB used?
  • CouchDB assists the users with useful data mapping which allows filtering, combining and querying the information.
  • CouchDB provides easy replication of the data, and as a result, data between the machines and databases can be copied, shared and synchronized.
  • CouchDB can be directly used to write a client’s application.There is no need for another server and as a result, the development time is reduced.
  • The filter feature of CouchDB SUPPORTS to replicate the database of a particular user and CouchDB also supports in replicating the database of a client.
Discussion