introduce yourself, tables, reports, nothing on fusion except tables
Oracle Software Engineer Interview Questions
537 oracle software engineer interview questions shared by candidates
Basic SQL ans PLSQL concepts
Questions about my previous role including team size and dynamics and any difficult situation I had to deal with.
Database questions based on materialized views, collections and triggers.
Pagination atomic integer interface and abstract class optimistic and pessimistic logging streams
Mostly they covered all SQL concepts
Asked all the questions about Oracle basic to advaced PLSQL. Given queries to remove duplicate records and to fetch the 3rd highest salary.
types of subqueries? and difference between them? types of triggers? types of trigger? write a trigger which will using do insert, update and delete on 'employee' table and keep audit in 'audit' table. if inserting insert into table also in audit table if deleting delete from also insert in audit table if upadte is require then update table and this update entry should insert in audit table types of cursors and create procedure take cursor and display emp name and salary.? what is database name? database structure you use to create database objects?
how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both
What are the constraints in MySQL?
Viewing 191 - 200 interview questions
See Interview Questions for Similar Jobs
Erp Software EngineerSap Software EngineerTechnology LeadOracle Soa DeveloperSenior Backend EngineerJava Solution ArchitectTechnical LeadSenior Back End EngineerSenior Software DeveloperJqueryFront End EngineerSenior Back-end EngineerMessage BrokerSoftware ArchitectSr. Software DeveloperSenior DeveloperSoftware Engineer Web DeveloperAws Solution Architect