Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TCS Team. If you also belong to the team, you can get access from here

TCS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

TCS Oracle Application Technical Consultant Interview Questions and Answers

Updated 7 Aug 2024

TCS Oracle Application Technical Consultant Interview Experiences

1 interview found

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • 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
  • 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

Skills evaluated in this interview

Interview questions from similar companies

I applied via Referral and was interviewed in Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SIP Call Flow, How to register the Media gateway, Integration of CMS and CDR with CM, Few scenario based troubleshooting related questions etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare what ever you mentioned in your CV.

I applied via Naukri.com and was interviewed in Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I have asked few technical questions and better sollutions for the technical broblem which i faced in my previous project?

Interview Preparation Tips

Interview preparation tips for other job seekers - I have followed few seps to crack the interviews.
1)Practice and Prepare well before attending the interview
2)Develop a Connection With the Interviewer because interaction is must
3) speak boldly with confidence alsomaintain eye contact with the interviewer.
4)During the job interview, try to relax and stay as calm as possible.
5)Also, have a list of your own questions to ask the employer ready.
6)Always follow up with a thank-you note reiterating your interest in the position.
7)Send your thank-you email within 24 hours of your interview.

I applied via Walk-in and was interviewed before Mar 2020. There were 5 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. What is SQL joins?
  • Ans. 

    SQL joins are used to combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables in a single query

    • Common types of joins include inner join, left join, right join, and full outer join

    • Joins are performed based on a related column between the tables

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. What is abstact class?
  • Q3. What are oops concepts?describe them.
  • Ans. 

    Oops concepts are the fundamental principles of object-oriented programming.

    • Abstraction: Hiding implementation details and showing only necessary information.

    • Encapsulation: Binding data and functions together in a single unit.

    • Inheritance: Acquiring properties and behavior of a parent class by a child class.

    • Polymorphism: Ability of an object to take many forms or have multiple behaviors.

    • Example: A car is an object that ...

  • Answered by AI
  • Q4. What are linked lists?
  • Ans. 

    Linked lists are a data structure consisting of nodes that point to the next node in the list.

    • Each node contains a value and a pointer to the next node.

    • Linked lists can be singly or doubly linked.

    • Insertion and deletion are efficient, but random access is not.

    • Examples include a queue, stack, and adjacency list.

  • Answered by AI
  • Q5. What is a collection framework??
  • Ans. 

    A collection framework is a set of classes and interfaces that provide a way to store and manipulate groups of objects.

    • It provides implementations of commonly used data structures like lists, sets, maps, etc.

    • It allows for easy manipulation of data stored in these structures.

    • Examples include Java's Collection and Map interfaces and their implementations like ArrayList, HashSet, and HashMap.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident enough to answer whatever you know. If you don't know anything, politely let them down.

Skills evaluated in this interview

I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Buisness process worked on , output determination, idoc , credit and debit memo
  • Ans. 

    The candidate has experience working on business processes, output determination, IDOC, credit and debit memos.

    • Candidate has worked on various business processes and has experience in output determination.

    • Candidate has knowledge of IDOC and its usage in SAP systems.

    • Candidate has experience in creating credit and debit memos.

    • Candidate can provide examples of their work in these areas.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It can be a long interview process .

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Question related to the Skill
  • Q2. Project related process Questions, SAP standard questions,
  • Q3. Scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Read all the SAP standard before interview.

I applied via LinkedIn and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Normal java questions. Restful API questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be ready with basics.

I applied via Job Portal and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Basic of voice concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with basics and have good positive attitude.

I applied via Referral and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Related to sap bo

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and know your skills....

I applied via Company Website and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basically they ask questions related to plugin, workflow and security role deeply.

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to explain all the answer with some real time experience

TCS Interview FAQs

How many rounds are there in TCS Oracle Application Technical Consultant interview?
TCS interview process usually has 1 rounds. The most common rounds in the TCS interview process are Technical.
How to prepare for TCS Oracle Application Technical Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at TCS. The most common topics and skills that interviewers at TCS expect are Oracle Apps, Oracle E - business Suite, PLSQL and R12.
What are the top questions asked in TCS Oracle Application Technical Consultant interview?

Some of the top questions asked at the TCS Oracle Application Technical Consultant interview -

  1. how would you relate one value set with another one in oracle a...read more
  2. how many type of report triggers are th...read more

Tell us how to improve this page.

TCS Oracle Application Technical Consultant Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
LTIMindtree Interview Questions
3.7
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
TCS Oracle Application Technical Consultant Salary
based on 77 salaries
₹3.4 L/yr - ₹16.2 L/yr
At par with the average Oracle Application Technical Consultant Salary in India
View more details

TCS Oracle Application Technical Consultant Reviews and Ratings

based on 3 reviews

4.7/5

Rating in categories

2.1

Skill development

2.3

Work-life balance

2.9

Salary

4.0

Job security

3.9

Company culture

4.5

Promotions

3.1

Work satisfaction

Explore 3 Reviews and Ratings
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
66.3k salaries
unlock blur

₹5 L/yr - ₹16 L/yr

AST Consultant
52k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Associate Consultant
30.5k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹2.2 L/yr - ₹5.8 L/yr

Explore more salaries
Compare TCS with

Amazon

4.0
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview