Infosys Oracle Technical Consultant Interview Questions and Answers for Freshers

Q1. How would you relate one value set with another one in oracle apps
Ans. 
Value sets can be related in Oracle Apps by using cross validation rules.
• Create cross validation rules to relate one value set with another

• Define the conditions under which values from one value set can be used with values from another

• Cross validation rules can be set up at the segment level in the value set definition

• Example: Creating a cross validation rule to ensure that a specific department can only be associated
Answered by AI
Add your answer
Q2. How many type of report triggers are there
Ans. 
There are 6 types of report triggers in Oracle Reports.
• BEFORE REPORT trigger

• AFTER REPORT trigger

• BEFORE PARAMETER FORM trigger

• AFTER PARAMETER FORM trigger

• BEFORE REPORT BODY trigger

• AFTER REPORT BODY trigger
Answered by AI
Add your answer

This is a basic mathematics test sometimes one section might be English

Q1. You should be prepared with technical skills according to your college curricular
Add your answer

They ask you to debug and place the correct code and run the code and get it executed.
They don't want you to execute all the questions good amount of questions need to be executed and your try to make the code execute matters

Q1. What are your salary expectations?
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. What are your strengths and weaknesses?
Add your answer
Q5. Tell me about yourself.
Add your answer
Q6. Willing to relocate - answer should be yes Do you lie for the company welfare and goodwill - answer yes and also mention that if no one is get affected
Add your answer