Module1_intro

Question 1

Postgres is based on what database?

Answer 1

ingres database same as SQL Server

Question 2

in what language is postgres written?

Answer 2

ANSI C

Question 3

PostgreSQL works on which OS’s?

Answer 3

Windows, Linux , Unix and MAC

Question 4

what is Multi-Version concurrency control?

Answer 4

Where user can see (old) data when a user is altering data but did not commit yet.

Question 5

Employs host-based acces control

Answer 5

postgres knows where connections can come from.

Question 6

Big data store formats

Answer 6

XML, JSON, PLB8, Hstore,non durable storage, full text indexing

Question 7

Foreign data wrappers

Answer 7

enable read/write integration with other database technologies (database link?)

Question 8

PostgresSQL connectors

Answer 8

JDBC, .NET, ECPG,LIBPQ, TCL, ODBC, NODE.JS, PYTHON, PErl DBI

Question 9

Maximum database size

Answer 9

unlimited

Question 10

Max table size

Answer 10

32TB

Question 11

Max Row Size

Answer 11

1.6 TB

Question 12

MAX field size

Answer 12

1 GB

Question 13

Max rows per table

Answer 13

unlimited

Question 14

Max columns per table

Answer 14

250-1600 depending on column types

Question 15

max indexes per table

Answer 15

unlimited and also multiple indexes on 1 column

Question 16

what is the name of Table, Row, Column, Data Block, Page in Postgres

Answer 16

Table = relation,
Row = tuple,
Column = attribute,
Data Block = page 8kb default (ON DISK),
Page =buffer (IN MEMORY)