Asked about the project I did in college.
Oracle Interview Questions
1,919 oracle interview questions shared by candidates
I wasn't asked any real technical questions. they are running single node Oracle databases from the ancient ( and most likely no longer supported ) Oracle 8 to Oracle 11. they are using Oracle's "Advanced Replication" feature which was advanced ten years ago. the local office has the support staff but didn't seem to have any managers. all development is outsourced to India and Russia.
Most of the questions were related to the work and the database stuff. There were some in-depth questions dealing with database internals.
self intro,back ground,education back ground
How do you handle the i expense reports for employee whose payroll as been transferred to US entity in the entity from where he was transferred
Database questions based on materialized views, collections and triggers.
How to create the instance from scratch
what is nvl; what is substring; what is joins, what is pseudocolumn, what is cursor, how to get the dense rank for table.
indepth discussion on projects worked on in the past
Most of the questions were expected.Scenario questions were bit tricky but the interviewer gave sufficient time to analyse and answer.
Viewing 791 - 800 interview questions
See Interview Questions for Similar Jobs
Oracle Solutions ArchitectCloud Di OracleConsultant OracleCloud ConsultantCloud ManagerOracle Principal ConsultantVirtualizationCloud ArchitectOracle Project ManagerOracle HrmsCloud AdministratorOracle Pl SqlConsultant Principal OracleConsultant CrmEnablementCloud OperationsAws Cloud ArchitectOracle Business Systems Analyst