Rman backup strategy How to export schema from source to target with different schema name at target. how will you act on performance issue. ASM components restoring a DB Dataguard related shell scripting Diskgroup space scenerio patch and upgrade
Database Administrator Ii Interview Questions
3,051 database administrator ii interview questions shared by candidates
high availability concepts
One of the Highest priority issue you encountered and resolved.
Rman backup scenarios? Dataguard protection?
SQL Questions easy to medium
Asked me to write algorithm
self intro, normal technical questions, performance related, scenario based..
1.what is Temp table and temp variable? 2. Stored Procedures ? 3. What are the nested loop joins 4. Merge joins and Hash joins 5 what are indexes , Cluster index and non-cluster index 6. you must work on performance tuning expert in postgrad SQL ? 7. query optimization? 8. what is statistics?
How to create a view to see the ongoing processes / queries in the db server?
What is the difference between Innodb and performance schema?
Viewing 3021 - 3030 interview questions