They asked me several questions about Oracle APEX, including creating pages, Interactive Grids, Dynamic Actions, validations, and basic SQL/PL/SQL concepts.
Consultant Oracle Interview Questions
1,922 consultant oracle interview questions shared by candidates
He asked about my state and then rejected based on it
Not any as I answered all technical questions. But experience with HR's was really horrible.
How do you analyse long running query? Difference between fs_clone and prepare?
Have you worked on a BPO setting?
Sql , plsql , Reports, Interface, oaf
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
Basic questions and indepth explanation required.
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
Viewing 1381 - 1390 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