Question will depend on the project for which they are looking for. Most of the question is on the latest features of Oracle, patching and performance tuning
Consultant Oracle Interview Questions
1,923 consultant oracle interview questions shared by candidates
What is PL? what are triggers? Difference between PL/SQL and SQL
Checked Experience, Technical And functional exposure
how to read explain plan and tuned the query?
How quickly can you join?
Explain the Org Structure P2P & O2C Life cycle and Mandatory Setups Types of Ledgers and it's significance Security Rule and CVR FA mandatory Setups Real time scenario like how to gather the Client requirements and implement the Modules
Explain about projects and your responsibilities? What is dual ? Difference between view and materialized view? What is substr and instr , syntax? Cursors,types of cursors and cursor attributes? Simple scenario given and instructed to write cursor and exception handling Psuedo columns in oracle? SQL loader
Related to BIP, integration, etc
Collections,Architecture
Tell me about Reim batch flow
Viewing 1911 - 1920 interview questions