PostgreSQL Database Administration Interview Questions

Interview Questions

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

What you’ll learn

  • PostgreSQL DBA concepts.
  • Real time questions included with answers.
  • Clear explanation of concepts.
  • Easily you will clear PostgreSQL DBA interviews.

Course Content

  • Introduction –> 1 lecture • 3min.
  • PostgreSQL terminology –> 1 lecture • 5min.
  • Architecture –> 1 lecture • 8min.
  • Database Cluster –> 1 lecture • 9min.
  • Configuration Files –> 1 lecture • 10min.
  • Schemas & Users & MVCC –> 1 lecture • 6min.
  • Tablespaces in PostgreSQL –> 1 lecture • 3min.
  • Backup & Restore –> 4 lectures • 24min.
  • Vacuum Operations –> 1 lecture • 6min.
  • Upgrade –> 0 lectures • 0min.
  • Replication –> 2 lectures • 9min.
  • Performance –> 1 lecture • 9min.
  • Miscellaneous –> 1 lecture • 1min.
  • Views in PostgreSQL –> 1 lecture • 1min.
  • Section 15 : Interview questions with answers –> 1 lecture • 1min.

Auto Draft

Requirements

  • Must and should have working experience in PostgreSQL Administration.

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

 

The course provides the candidate with an extensive knowledge of PostgreSQL Database Administration with real life scenarios .

 

Topics discussed are:

 

  • PostgreSQL Database Naming Conventions
    • PostgreSQL Database Data Directory

     

    • PostgreSQL Database default Bin Directory

 

  • PostgreSQL Database default configuration files location

 

  • PostgreSQL Database  Maintenance

 

  • PostgreSQL Database Architecture

 

  • PostgreSQL Database Backup & Recovery

 

  • PostgreSQL Database Performance

 

  • PostgreSQL  Database  Cluster

 

  • PostgreSQL  Database Replication

 

  • PostgreSQL Database Upgrade

 

  • PostgreSQL Database/Tables Vacuum operations

 

  • PostgreSQL Database Views

 

  • PostgreSQL Database Tablespace management

 

  • PostgreSQL Database  Users

 

  • PostgreSQL Database Schemas
  • PostgreSQL Database Configuration Files

Minimum hardware required to install and run PostgreSQL are:

============================================

a 1 GHz processor.

2 GB of RAM.

512 MB of HDD.

 

Software Requirements

root or super user access is required on Linux Systems

Views in postgreSQL

==============

pg_aggregate aggregate functions

pg_am index access methods

pg_amop access method operators

pg_amproc access method support procedures

pg_attrdef column default values

pg_attribute table columns (“attributes”)

pg_authid authorization identifiers (roles)

pg_auth_members authorization identifier membership relationships

pg_cast casts (data type conversions)

pg_class tables, indexes, sequences, views (“relations”)

pg_constraint check constraints, unique constraints, primary key constraints, foreign key constraints

pg_collation collations (locale information)

pg_conversion encoding conversion information

pg_database databases within this database cluster

pg_db_role_setting per-role and per-database settings

pg_default_acl default privileges for object types

pg_depend dependencies between database objects

pg_description descriptions or comments on database objects

pg_enum enum label and value definitions

pg_extension installed extensions

pg_foreign_data_wrapper foreign-data wrapper definitions

pg_foreign_server foreign server definitions

pg_foreign_table additional foreign table information

pg_index additional index information

pg_inherits table inheritance hierarchy

pg_language languages for writing functions

pg_largeobject data pages for large objects

pg_largeobject_metadata metadata for large objects

pg_namespace schemas

pg_opclass access method operator classes

pg_operator operators

pg_opfamily access method operator families

pg_pltemplate template data for procedural languages

pg_proc functions and procedures

pg_rewrite query rewrite rules

pg_seclabel security labels on database objects

pg_shdepend dependencies on shared objects

pg_shdescription comments on shared objects

pg_statistic planner statistics

pg_tablespace tablespaces within this database cluster

pg_trigger triggers

pg_ts_config text search configurations

pg_ts_config_map text search configurations’ token mappings

pg_ts_dict text search dictionaries

pg_ts_parser text search parsers

pg_ts_template text search templates

pg_type data types

pg_user_mapping mappings of users to foreign servers

Get Tutorial