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
3.7

based on 84.5k Reviews

Filter interviews by

TCS Oracle Developer Interview Questions and Answers

Updated 21 Dec 2022

TCS Oracle Developer Interview Experiences

2 interviews found

I applied via Company Website and was interviewed in May 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. In Tr they have asked basics questions related to java like oops concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be focus on the question they have asked be attentive and honest

I applied via Campus Placement and was interviewed before Dec 2021. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 

All type of aptitude questions

Round 3 - Coding Test 

We can choose what language we can write

Round 4 - Technical 

(1 Question)

  • Q1. In technical round most of the questions was asked based on programming language that u know and prepare for scenario based question
Round 5 - HR 

(1 Question)

  • Q1. Prepare all related HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident enough even though you don't know the answer just say

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Mainly they focus on PLSQL query .
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
-

I was interviewed in Mar 2024.

Round 1 - Technical 

(1 Question)

  • Q1. 1 Write a procedure using user defined exception 2 write a procedure to get error, if updating end of the month. Etc....
  • Ans. 

    Creating procedures with user defined exceptions and handling errors when updating at end of month.

    • Create a procedure with a user defined exception using 'RAISE_APPLICATION_ERROR' and 'EXCEPTION' keywords.

    • Use 'TO_CHAR(SYSDATE, 'DD')' to check if it is the end of the month before updating.

    • Handle the error by raising an exception if the update is attempted at the end of the month.

    • Example: CREATE OR REPLACE PROCEDURE upda...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What have you worked on?
  • Q2. What is a cursor and types?
  • Ans. 

    A cursor is a database object used to manipulate data in a result set.

    • A cursor is used to retrieve and manipulate data row by row.

    • Types of cursors include implicit, explicit, and forward-only cursors.

    • Implicit cursors are automatically created by Oracle when executing a SQL statement.

    • Explicit cursors are created by the developer and allow for more control over the result set.

    • Forward-only cursors only allow for iterating

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be sure and confident about the work you have done and present it before them.

I applied via Referral and was interviewed in Sep 2021. There were 2 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oracle questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. How would you monitor a db performance with OEM AWR report?
  • Ans. 

    Monitoring db performance using OEM AWR report

    • Access OEM console and navigate to Performance tab

    • Select AWR report option to generate a report

    • Analyze the report for key performance metrics like CPU usage, memory utilization, I/O stats

    • Identify any performance bottlenecks and take necessary actions to optimize db performance

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Accenture Oracle Database Administrator interview:
  • Dataguard
  • BACKUP & recovery
  • ASM
  • Oracle RAC
Interview preparation tips for other job seekers - Be strong with basic knowledge of the how to configure, install, patch, migrate and upgrade database.. if you have mentioned RAC and performance tuning they expect you to answer more and dive deep into scenarios. Dataguard, ASM they would expect to have knowledge in these areas as well.. Moreover, have a throughout preparation based on scenarios, as they expect you to answer in scenarios where you don’t have OEM as a monitoring tool.. and if things are manually done..
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Maths reasoning english

Round 2 - Coding Test 

Problem solving based question

Round 3 - HR 

(1 Question)

  • Q1. Basic on location shift jobs etc
Round 4 - Technical 

(1 Question)

  • Q1. Networking database Linux windows
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell about yourself
  • Ans. 

    Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.

    • 5+ years of experience as an Oracle DBA

    • Proficient in database management, performance optimization, and data security

    • Skilled in troubleshooting and resolving database issues

    • Strong knowledge of Oracle database architecture and SQL

    • Certified Oracle Database Administrator (OCA/OCP)

  • Answered by AI

I applied via Naukri.com and was interviewed in May 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Purpose of po ,O2C cycle, P2P cycle discussion, debit memo, credit memo, inventory topics
  • Ans. 

    Discussion on PO, O2C cycle, P2P cycle, debit memo, credit memo, and inventory topics for Oracle SCM Functional Consultant role.

    • PO (Purchase Order) is a document used to request goods or services from a supplier.

    • O2C (Order to Cash) cycle involves the entire process from receiving an order to receiving payment.

    • P2P (Procure to Pay) cycle involves the entire process from identifying a need to paying the supplier.

    • Debit mem...

  • Answered by AI
  • Q2. Key flexifields, order to cash
  • Q3. Advance priceing,cash memo
Round 3 - Technical 

(1 Question)

  • Q1. Examples of day to day issues

Interview Preparation Tips

Interview preparation tips for other job seekers - When you attend interview be prepared tharoughly, examples of bug related issues of your experience.

TCS Interview FAQs

How many rounds are there in TCS Oracle Developer interview?
TCS interview process usually has 5 rounds. The most common rounds in the TCS interview process are Resume Shortlist, Assignment and Coding Test.
How to prepare for TCS Oracle Developer 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, PLSQL, Database Design, Oracle Development and PL.
What are the top questions asked in TCS Oracle Developer interview?

Some of the top questions asked at the TCS Oracle Developer interview -

  1. In technical round most of the questions was asked based on programming languag...read more
  2. In Tr they have asked basics questions related to java like oops conce...read more

Tell us how to improve this page.

People are getting interviews through

based on 2 TCS interviews
Company Website
Campus Placement
50%
50%
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates

Interview Questions from Similar Companies

Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
LTIMindtree Interview Questions
3.9
 • 2.7k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
TCS Oracle Developer Salary
based on 93 salaries
₹3 L/yr - ₹9.9 L/yr
6% less than the average Oracle Developer Salary in India
View more details

TCS Oracle Developer Reviews and Ratings

based on 11 reviews

3.3/5

Rating in categories

3.7

Skill development

3.4

Work-Life balance

2.4

Salary & Benefits

4.2

Job Security

4.0

Company culture

2.3

Promotions/Appraisal

2.9

Work Satisfaction

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

₹1 L/yr - ₹9 L/yr

IT Analyst
68.2k salaries
unlock blur

₹5.1 L/yr - ₹15.8 L/yr

AST Consultant
50.9k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Assistant System Engineer
31.4k salaries
unlock blur

₹2.2 L/yr - ₹5.6 L/yr

Associate Consultant
28.4k salaries
unlock blur

₹8.9 L/yr - ₹31.5 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview