Top 40+ Postgresql Interview Questions 2021 - { What is PostgreSQL }

Ques:- What is PostgreSQL?

Postgresql Interview Questions 2021 - InterviewMocks: About PostgreSQL, PostgreSQL is a relational database management system that is highly extensible and has high compliance with technical standards. PostgreSQL handles a wide range of workloads from a machine to data warehouses or web services used by many users at a time. PostgreSQL automatically updates views and follows ACID ( Atomicity, Consistency, Isolation, Durability) properties...

• 
  

• Explain the History of PostgreSQL

PostgreSQL, originally called Postgres, was created at UCB by a computer science professor named Michael Stonebraker. Stonebraker started Postgres in 1986 as a follow-up project to its predecessor, Ingres, now owned by Computer Associates.

• 1977-1985  − A project called INGRES was developed.

  •          Proof-of-concept for relational databases

  •          Established the company, Ingres, in 1980

  •          Bought by Computer Associates in 1994

• 1986-1994 − POSTGRES

  • Development of the concepts in INGRES with a focus on object orientation and the query language - Quel

  • The codebase of INGRES was not used as a basis for POSTGRES

  • Commercialized as Illustra (bought by Informix, bought by IBM)

• 1994-1995 − Postgres95

•         Support for SQL was added in 1994

•          Released as Postgres95 in 1995

•          Re-released as PostgreSQL 6.0 in 1996

•          Establishment of the PostgreSQL Global Development Team

Features of PostgreSQL

PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It supports text, images, sounds, and video, and includes programming interfaces for C / C++, Java, Perl, Python, Ruby, Tcl, and Open Database Connectivity (ODBC).

PostgreSQL supports a large part of the SQL standard and offers many modern features including the following −

• Complex SQL queries
• SQL Sub-selects
• Foreign keys
• Trigger
• Views
• Transactions
• Multiversion concurrency control (MVCC)
• Streaming Replication (as of 9.0)
• Hot Standby (as of 9.0)

You can check the official documentation of PostgreSQL to understand the above-mentioned features. PostgreSQL can be extended by the user in many ways. For example by adding new −

• Data types
• Functions
• Operators
• Aggregate functions
• Index methods

Read more Questions...