PostgreSQL Question:

Download Job Interview Questions and Answers PDF

Explain about concurreny with the help of MVCC?

PostgreSQL Interview Question
PostgreSQL Interview Question

Answer:

Multi version concurrency control is used to manage concurrency. This feature is very useful because changes made in the database will not be visible to other users until the transaction is completed. This removes the need for read locks. ACID principles are given a further boost by this feature and can be implemented in general.

Download PostgreSQL Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about string constants?How to created a database?