Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 2 giorni. Ho sostenuto un colloquio presso Oasis TechnoSoft (Gurgaon, Haryana) nel mese di apr 2025
Colloquio
The Interview was fine. They expect an Oracle Apps Tech Consultant to know broadly all the topics related to the Oracle EBS Application, including SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, XML Bursting, Oracle EBS 11i/R12 Functional Knowledge, etc.
Domande di colloquio [14]
Domanda 1
Introduce yourself briefly, mention details about your profile and responsibilities from your previous job.
SQL - Let's say we have some data in a column of a particular table, and that data contains some special characters or that data has some issues, then how would you fix it? (Hint - Use Regular Expression REGEXP)
PL/SQL - Let's say we have a PL/SQL block in which we have 2 Exceptions. 1) WHEN NO_DATA_FOUND THEN 2) WHEN OTHERS THEN. In the Exception part of the block, the exception - WHEN OTHERS THEN is written before WHEN NO_DATA_FOUND Exception. Then what kind of error do you get? Will the code work? (Hint - Compilation Error)