PostgreSQL Database Administration Interview Questions

Interview Questions

What you'll learn
PostgreSQL DBA concepts
Real time questions included with answers
Clear explanation of concepts
Easily you will clear PostgreSQL DBA interviews
Requirements
Must and should have working experience in PostgreSQL Administration
Description
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

Who this course is for
DBA's
DB developers who are interested in PostgreSQL Administration and willing to do Administration activities