-
40 IBM Oracle DBA Interview Questions
1) How to install patches? And what are pre-requsites?
2) How to upgrade 10.2.0.1 to 10.2.0.4 AND 11.2.0.1 to 11.2.0.3 and 10.2.0.4 to 11.2.0.1?
3) How to take the backup of oracle_home and oracle_inventory?
4) What is OCR & voting disk?
5) How to take backup of OCR and voting?
6) Which one take backup if OCR and voting disk?
7) Suppose lose OCR what happen... -
-
-
-
-
-
-
-
-
-
-
-
Changed Performance
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
-
Alert log files
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
-
DB Server Performance Bottlenecks
What are four performance bottlenecks that can occur in a database server and How are they detected?
-
Why we use materialized View? or when do i go for an Materialized View
Please Give any scenario (Or) example of its very help full?
-
Temp Table Space
Temp table running out of space, What will you do?
-
-
-
Oracle DBA Interview Questions
Ans