He had made some questions like ONE SIZE FITS ALL for all Oracle modules such as Order to Cash, Purchase, Inventory, etc and asked all random questions one after the other. If a question was outof their job scope and they think for a minute before answering he mentioned OK YOU KEEP THINKING LATER NOW I WILL ASK NEXT QUESTION. (3) He was highly sarcastic of every word in resume and sort of challenged on them with toxic comments.
The Questions were like Joins, How to insert CSV file in sql Analytical functions Nth Salary Can we use conditional statements in select query
Basics and scenario based tech questions.
Bulk Collect Context Switching O2C cycle
Upgradation, cloning patching and any challenged tasks.
How to update only single column of a table without using update keyword.
It was programing aptitude round asked about procedure, triggers, views
What is Trigger? The code
Find the department ID that has the highest average maximum salary
What is the difference between where and having clauses?
Viewing 1051 - 1060 interview questions