PostgreSQL Interview Questions

 
1.
Explain what is PostgreSQL?
2.
State some of the advanced features of PostgreSQL?
3.
Explain about Write Ahead logging?
4.
Explain about Multi version concurrency control?
5.
How to start the database server?
6.
How to stop the database server?
7.
How to check whether PostgreSQL server is up and running?
8.
What are the languages which PostgreSQL supports?
9.
Explain about the command enable debug?
10.
Explain about functions in PostgreSQL?
11.
Explain about indices of PostgreSQL?
12.
Explain about Triggers?
13.
What are the different data types supported by PostgreSQL?
14.
Explain about database administration tools?
15.
Explain about pgadmin?
16.
How do you create a data base with postgreSQL?
17.
What are the various enhancements to the straight relational data model by PostgreSQL?
18.
Explain about tokens?
19.
Explain about string constants?
20.
Explain about concurreny with the help of MVCC?
21.
How to created a database?
22.
How to list the number of database?
23.
How to take backup of database?
24.
How to create a PostgreSQL user?