How do you analyse long running query? Difference between fs_clone and prepare?
Database Coordinator Interview Questions
4,480 database coordinator interview questions shared by candidates
Fixing performance issues and implementing features, system design, reading query plan and statistics
1TB doesn't seem like a lot of data. Can you explain what were your challenges when going through that much data?
1. Have you used trigger before? 2. What is the stored procedure? 3. How do you deal with slow query? 4. What is the difference between temp table and view?
Describe Oracle Architecture
ETL Tuning methods - Oracle
What are the different stats types.
Describe the node eviction and what causes it? What is OCLUMON? How would you tune query? How to backup a NOARCHIVELOG database without shutting it down? What is Fast Start Failover? Difference between ASMM and AMM?
General question
real time scenarios only
Viewing 2791 - 2800 interview questions