Home 
Do you have any collection of Interview Questions and interested to share with us!!
Please send that collection to iq@GlobalGuideline.Com along with the category and sub category information
Please send that collection to iq@GlobalGuideline.Com along with the category and sub category information
1 :: Explain what is PostgreSQL?
This is regarded as one of the most successful open source database in the world. This is also used to create advanced applications. This relies on Object relational database management system. Familiarity with UNIX and Linux can be an added advantage while using PostgreSQL.2 :: State some of the advanced features of PostgreSQL?
These are the following features which are present in PostgreSQL they are1) Object relational database
2) Extensibility and support for SQL
3) Database validation and flexible API
4) Procedural languages and MVCC
5) Client server and WAL.
3 :: Explain about Write Ahead logging?
This feature increases the reliability of the database by logging changes before any changes or updations to the data base. This provides log of database incase of a database crash. This helps to start the work from the point it was discontinued.4 :: Explain about Multi version concurrency control?
Multi version concurrency control or MVCC is used to avoid unnecessary locking of the database. This removes the time lag for the user to log into his database. This feature or time lag occurs when some one else is on the content. All the transactions are kept as a record.5 :: How to start the database server?
/usr/local/etc/rc.d/010.pgsql.sh start/usr/local/etc/rc.d/postgresql start
Webmaster Said:
Thank you.