recovery

Real Interview questions for experienced DBAs – 1

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...

How to change port number in postgres

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'; ...

How to use flashback query in oracle database

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 ...