He asked about my state and then rejected based on it
Consultant Oracle Interview Questions
1,922 consultant oracle interview questions shared by candidates
Not any as I answered all technical questions. But experience with HR's was really horrible.
bind variables dynamic sql external table views mviews query to sum up pesudo columns virtual coulmns packages and advantages truncate delete exists in merge joins clustered index partitions interval partitioning puring partition loaders schema used in DB design diff between olap oltp scd collections bulk collect ref cursor unique key and primary key if base table is not present can we build the view corelated and subquery how to redirect o/p of the command in shell script
mostly they asked me the issues i faced and did not have any technical questions for me that much they were asking about pl/sql develpment
Basic questions and indepth explanation required.
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
performance tuning techniques and its use
How do you analyse long running query? Difference between fs_clone and prepare?
How to import into different user/tablespace/datafile/table?
Viewing 1361 - 1370 interview questions
See Interview Questions for Similar Jobs
Consultant PeoplesoftConsultant Oracle RetailConsultant Principal OracleConsultant Oracle ErpConsultant Applications OracleOracle Financials FonctionnelConsultant Sap CrmConsultant Principal Sap FicoConsultant Fonctionnel Oracle HrmsConsultant Fonctionnel Applications OracleConsultant Fonctionnel OracleOracle Applications Business Analyst FonctionnelConsultant Senior En Applications OracleConsultant Sap SdConsultant Oracle Fusion CrmAnalyste Commercial PeoplesoftConsultant ObieeConsultant Sap Basis Senior