16
Miscellaneous Questions
1. Write a short note on PostgreSQL. Discuss its various features.
Ans: PostgreSQL is the most advanced and widely used open source object-relational database system. It comes with a BSD license that allows everyone to use, modify and distribute its code and documentation for any purpose without any charge. The current version of PostgreSQL is fully ACID compliant and has full support for foreign keys, joins, triggers, views, stored procedures, multiversion concurrency control and write ahead logging. It includes most of the SQL92 and SQL99 data types and allows users to define new data types also. In addition, it has interfaces for many programming languages like C, C++, Java, Perl, and Python and it runs on almost ...
Get Express Learning: Database Management Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
