Overview: Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds.   Round 1 :  What are your day to day activities. And what is...

This article explains how to change the port number in postgres. We will change the port from 5444 to 5432 . 1. Check the existing port details postgres=# select * from pg_settings where name='port'; ...

This flashback query  allows us  to query a table at a point in the past. We can retrieve which we might have deleted by  mistake in the past.   Make sure flashback is enabled: SQL> select ...