Oracle DBA Interview Questions
What are the versions you are working on
Database
RAC database
Dataguard
What is the recent patch you applied?
What happens when you run Root.sh during installation
RAC Architechture?
What is Node Eviction? In what scenarios the node be evicted? Which background process is responsible for node eviction and fixing evicted node and bringing into cluster? How do you troubleshoot Node Eviction?
What is cache fusion? What is responsible for cache fusion?
How will you take VD backup in 11gR1 and 11gR2?
How to check VD backup location
How to check OCR backup location
Starup Restrict vs Startup Upgrade
Difference between 11g and 10g ?
Difference between sga_target and memory_target?
Difference between 11gR2,11gR1,10gR2 and 10gR1 RAC ?
Materialized views and its types
Database upgrade takes 1hr normally and client want to upgrade without down time.
How can you achieve that in a RAC and Standalone.How can we upgrade with only 5 min downtime instead of 1 hour, as per client requirement?
Can exp be faster than expdp? If yes? In which scenario it happens?
Exp vs Datapump
Datapump vs RMAN
If RMAN backs up only changed blocks, what happens if the database has some read only ts and I have taken level 0 backup. Will the readonly ts backs up or not as there are no changed blocks in them?
What is Dataguard?
Logical vs Physical Standby databases?
Protection modes in Dataguard? What Protection mode do you have in your project?
DB_LINK? Syntax?
DB_LINK VS NETWORK_LINK in Datapump
what happens internally when you export or import in Datapump
How to check whether DATAPUMP dump File is corrupted or not?
How to see the DDL contents of an export dump file in Data Pump import and Traditional import?
Datapump Import failed after running for long time and even resumable time also execeeded? What action will you take?
Datapump Import hanged after running for long time? What action will you take?
How will you stop and start an import in datapump.
From which view you will find out datapump jobs?
Tell me some issues you faced with Datapump and how did you fix them?
Tell me the toughest issue you faced with Dataguard and how did you fix it?
Tell me the toughest issue you faced with RAC and how did you fix it?
Tell me the toughest issue you faced in Performance Tuning and how did you fix it?
CPU VS PSU Patching? What patching you are implementing in your project?
What is the full form of Opatch
opatch apply vs napply
Pre requirement for upgrade to 11g from 10g.
Steps for database cloning using RMAN
Steps for DR rebuild
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Temp ts is 100% full,adding space still filling up, we cant add more space to it, what fix will you apply?
How to make RMAN backups run faster?
What is block change tracking? How does it work?
Apps team complained database is performing slow? How will you confirm the slowness being a DBA ? What actions will you perform?
Apps team complained database performence is low compared to last week? What actions will you take?
Which columns will you check in active_session_history
Write query for populating Active sessions excluding background processes?
Fast failover in DG? Is Fast Failover there in your environment?
What is a Scan listener? How it works?
What are the versions you are working on
Database
RAC database
Dataguard
What is the recent patch you applied?
What happens when you run Root.sh during installation
RAC Architechture?
What is Node Eviction? In what scenarios the node be evicted? Which background process is responsible for node eviction and fixing evicted node and bringing into cluster? How do you troubleshoot Node Eviction?
What is cache fusion? What is responsible for cache fusion?
How will you take VD backup in 11gR1 and 11gR2?
How to check VD backup location
How to check OCR backup location
Starup Restrict vs Startup Upgrade
Difference between 11g and 10g ?
Difference between sga_target and memory_target?
Difference between 11gR2,11gR1,10gR2 and 10gR1 RAC ?
Materialized views and its types
Database upgrade takes 1hr normally and client want to upgrade without down time.
How can you achieve that in a RAC and Standalone.How can we upgrade with only 5 min downtime instead of 1 hour, as per client requirement?
Can exp be faster than expdp? If yes? In which scenario it happens?
Exp vs Datapump
Datapump vs RMAN
If RMAN backs up only changed blocks, what happens if the database has some read only ts and I have taken level 0 backup. Will the readonly ts backs up or not as there are no changed blocks in them?
What is Dataguard?
Logical vs Physical Standby databases?
Protection modes in Dataguard? What Protection mode do you have in your project?
DB_LINK? Syntax?
DB_LINK VS NETWORK_LINK in Datapump
what happens internally when you export or import in Datapump
How to check whether DATAPUMP dump File is corrupted or not?
How to see the DDL contents of an export dump file in Data Pump import and Traditional import?
Datapump Import failed after running for long time and even resumable time also execeeded? What action will you take?
Datapump Import hanged after running for long time? What action will you take?
How will you stop and start an import in datapump.
From which view you will find out datapump jobs?
Tell me some issues you faced with Datapump and how did you fix them?
Tell me the toughest issue you faced with Dataguard and how did you fix it?
Tell me the toughest issue you faced with RAC and how did you fix it?
Tell me the toughest issue you faced in Performance Tuning and how did you fix it?
CPU VS PSU Patching? What patching you are implementing in your project?
What is the full form of Opatch
opatch apply vs napply
Pre requirement for upgrade to 11g from 10g.
Steps for database cloning using RMAN
Steps for DR rebuild
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Temp ts is 100% full,adding space still filling up, we cant add more space to it, what fix will you apply?
How to make RMAN backups run faster?
What is block change tracking? How does it work?
Apps team complained database is performing slow? How will you confirm the slowness being a DBA ? What actions will you perform?
Apps team complained database performence is low compared to last week? What actions will you take?
Which columns will you check in active_session_history
Write query for populating Active sessions excluding background processes?
Fast failover in DG? Is Fast Failover there in your environment?
What is a Scan listener? How it works?
No comments:
Post a Comment