What is difference btw ETL and ELT?
Oracle Software Engineer Interview Questions
537 oracle software engineer interview questions shared by candidates
Topics included triggers, indexes and sql tuning concepts and difference between union and union all.
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
General screening question
What are the components of sql?
Where do you see yourself in 15 years?
Performance tunning in Oracle PLSQL
SOA Features MDS JMS fault policies
Discussion about Oracle Cloud Experience, Migration from legacy systems, Table Architecture, P2P Flow, O2C Flow. Behavioral questions includes, handling an irate/upset user, conflict management, handling an unhappy manager etc
technical questions
Viewing 341 - 350 interview questions