PostgreSQL Questions

What is the default port number for Postmaster?

• 5432

• 5462

• 1234

• 1542

If postgresql.conf and postgresql.auto.conf both have the same parameter, then which file takes precedence?

• postgresql.conf

• postgresql.auto.conf

Which utility has to be used to create a PostgreSQL Cluster?

• pgAdmin

• psql

• pg_ctl

• initdb

WAL stands for

• Write Ahead List

• Write Anywhere List

• Write Anywhere Logging

• Write Ahead Log

What is the command that has to be run to re-read the pg_hba.conf file?

• pg_ctl updateread

• pg_ctl loadagain

• pg_ctl reread

• pg_ctl reload

By default, in what subdirectory of the database data directory are WAL logs contained?

• pg_walfiles

• pg_locwal

• pg_walloc

• pg_wals

What are the join strategies available to the PostgreSQL planner when a SELECT query contains two or more relations?

• Nested Loop Join, Merge Join, Hash Join

• MERGE, JOIN

• INNER JOIN, OUTER JOIN

• MERGE, INNER JOIN, OUTER JOIN

The archive_mode initialization parameter enables WAL archives

• TRUE

• FALSE

Which process writes data into the WAL File?

• RS Process

• LGWr

• GMON Writer

• WAL Writer

Does FullVacuum hold an exclusive Lock?

• TRUE

• FALSE