This article explain From postgres, how can we fetch oracle db data. For this we need to use foreign data wrapper and foreign table concepts. DEMO: 1.Create oracle client on postgres server: ...
oracle
Real DBA Interview questions -4
Below are the questions asked to a candidate in a production based company. In ansible, what type of activites you did? What is a role in ansible? How you can print the output in ansible task? ...
Real DBA interview questions -3
These below oracle DBA questions has been shared by a candidates who appeared for a interview in MNC. Candidate has 10 years of experience . ROUND 1: ( Technical Round) Background processes in oracle ...
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 find when a table was last modified in oracle
If you want to find, when a table was last modified like insert,update ,delete, then use the dictionary table dba_tab_modifications. SCENARIO: 1. Insert into test data: SQL[SCOTT@TDB01]SQL>&g...
How to deinstall oracle client
We can deinstall oracle client by runnning the deinstall tool provided by oracle client software. [oracle@bt-Prov-devst1 client_1]$ cd deinstall/ [oracle@bt-Prov-devst1 deinstall]...
How to get the character set of a database in oracle
A character set determines what languages can be represented in the database. Oracle recommends Unicode AL32UTF8 as the database character set. Unicode is the universal character set that supports mos...