They asked me mostly about my experience and how i faced issues in other places. We discussed things together instead of being very technical.
Database Interview Questions
5,615 database interview questions shared by candidates
How do you analyse long running query? Difference between fs_clone and prepare?
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
Viewing 3921 - 3930 interview questions
See Interview Questions for Similar Jobs
Sql DatabaseDelphi DeveloperJunior Database DeveloperJunior Database AdministratorSql Database DeveloperSenior Database DeveloperEntry Level Database DeveloperProgrammer Analyst Sql Server DeveloperJunior Programmer AnalystVba Excel DeveloperMis Reporting AnalystSql Server Database DeveloperDatabase SpecialistTrading Systems Support AnalystSql Server DatabaseFilenetSql ServerSql