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 15 PostgreSQL Interview Questions for 2022

1) What is PostgreSQL?

PostgreSQL is a most advance open source database system. PostgreSQL is an object Oriented Relational Database Management System (ORDBMS). PostgreSQL source code is available free of charge and it is not controlled by any corporation.

2) What are the features provided by PostgreSQL?

Following advance features are provided by PostgreSQL:
Indexes
Triggers
Multiversion concurrency control (MVCC).
Complex SQL queries
SQL Sub-selects
Foreign keys
Views
Tablespaces
Point-in-time recovery

3) Name data types which are used in PostgreSQL.

PostgreSQL supports the following data types:
Booloean
Character (char, varchar, text)
Numeric (Integer, Floating-point)
Temporal (date, time, timestamp, interval)
Array (array string, number)
JSON
hstore (key-value pair)

4) What are the different database tools for PostgreSQL?

Following are the database tools are used for PostgreSQL:
  • Psql
  • Pgadmin
  • Phppgadmin

5) How to start the PostgreSQL database server?

/usr/local/etc/rc.d/010.pgsql.sh start
/usr/local/etc/rc.d/postgresql start

6) How to check whether PostgreSQL server is running?

/usr/local/etc/rc.d/010.pgsql.sh status
/usr/local/etc/rc.d/postgresql status

7) How to stop the PostgreSQL database server?

/usr/local/etc/rc.d/010.pgsql.sh stop
/usr/local/etc/rc.d/postgresql stop

8) How to create PostgreSQL user?

Syntax:
CREATE USER user_name with condation;
Example:
CREATE USER Rohan with password="password";

9) How to create database?

There are two ways to create database in PostgreSQL:
Using CREATE DATABASE command
Using createdb a command line executable.
Syntax:
CREATE DATABASE database_name;
Example: In PosstgreSQL schema the above command is written as:
postgres=# CREATE DATABASE database_name;

10) How to drop PostgreSQL database?

DROP DATABASE command deletes all information (table, view, procedure etc) stored in the database. Example:
DROP DATABASE database_name;

11) How to create a new table in PostgreSQL?

We can create a new table by specifying table name, column name with their data type. Syntax:
CREATE TABLE tablename(column1 datatype, column2 datatype);
Example:
CREATE TABLE employee(  
id int,  
 name varchar(20),  
  salary int,  
);

12) How to drop table from database?

DROP TABLE command is used to remove (delete) table and all its data, rules, indexes, constraints etc from database. Syntax:
DROP TABLE table_name;

13) What is TRUNCATE statement?

TRUNCATE TABLE statement is used to remove all data quickly and efficiently from the table. Syntax:
TRUNCATE TABLE table_name;

14) What is DELETE statement in PostgreSQL?

DELETE statement is used to delete rows from the table. Syntax:
DELETE FROM table_name WHERE condation;

15) Compare TRUNCATE, DROP and DELETE statement for table in PostgreSQL.

Suppose that we have a database with name employeedb contain table employee_table. Let consider employee_table has following structure.
emp_id emp_name emp_salary department
101 Ajay 35000 Sales
102 Prakas 40000 Finance
103 Sunil 45000 IT
Let see what happen when we execute the above statements: DELETE FROM employee_table WHERE emp_id=102; It gives the following result.
emp_id emp_name emp_salary department
101 Ajay 35000 Sales
103 Sunil 45000 IT
TRUNCATE TABLE employee_table; It gives the following result.
emp_id emp_name emp_salary department
DROP TABLE employee_table; It remove complete table from database employeedb.