Knowledge about data modelling
Oracle Database Interview Questions
505 oracle database interview questions shared by candidates
Work strategy and culture
little bit from performance tuning.
No difficult or unexpected questions
What was the size of database you handelled.
It's 10am on Wednesday morning and you get a call from 2 users saying a report they run daily that normally takes 5 mins to run, has been running for the past 30 mins. Q. What questions would you ask ? How would you go about resolving the situation ? Q. How would you identify fragmentation ? How would you resolve it ?
list Various listener commands, diff btn lock and latch, types of standby databases available, calculate cache hit rate and miss rate, groupby orderby diff...
Wat is database instance?? And queries of SQL.be well prepared with SQL and Oracle database
1)How would you resolved blocking / locking and what's the approach for investigating problematic sql's
How do you identify long running SQL queries
Viewing 251 - 260 interview questions
See Interview Questions for Similar Jobs
Oracle Database DeveloperSql DeveloperPlsql DeveloperHadoop Developer Or Hadoop AdministratorSenior Database DeveloperSenior Oracle Database AdministratorSql Database EngineerJunior Oracle Database AdministratorSql Server Database DeveloperSenior Database EngineerSql Database DeveloperDatabase Del Server SqlIt Technical AnalystOracle Plsql DeveloperOracle Pl Sql DeveloperSenior Pl Sql DeveloperPower Bi Support EngineerHadoop Administrator