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 Database Administrator Interview Questions and Answers

Updated 21 Sep 2024

TCS Oracle Application Database Administrator Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. OEM services-related Questions
  • Q2. What is Oracle Block Change
  • Ans. 

    Oracle Block Change is a feature that tracks and records changes made to database blocks.

    • Oracle Block Change is used for efficient data replication and synchronization.

    • It helps in identifying and transferring only the changed data blocks instead of the entire database.

    • Oracle GoldenGate utilizes Oracle Block Change technology for real-time data integration.

    • Block Change Tracking (BCT) is a feature in Oracle Database that...

  • Answered by AI
  • Q3. In RAC database 2 nodes are there how you will re-direct users to 2nd node only?
  • Ans. 

    To redirect users to the 2nd node in a RAC database, you can use services and connection load balancing.

    • Create a service for the 2nd node in the RAC database.

    • Configure connection load balancing to distribute connections evenly between the nodes.

    • Update the connection string in the application to point to the service for the 2nd node.

    • Test the connection to ensure users are redirected to the 2nd node.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was based on my experience which I have mentioned in resume.
some were situation based Questions and some were direct questions like
What is BCT, how to make DB available for max? etc etc

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: Resume Shortlist
Experience: A telephonic of technical round basics about C concepts and Embedded C Concepts in order to call for next round .

I applied via Other and was interviewed in Nov 2017. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Brief Role on job and tools and technology I worked with day to day activity
  • Ans. 

    As a Senior Software Engineer, I worked with various tools and technologies to develop and maintain software applications.

    • Developed and maintained software applications using Java, Python, and C++ programming languages

    • Used Agile methodology for software development and collaborated with cross-functional teams

    • Worked with various tools such as Git, JIRA, Jenkins, and Docker for version control, issue tracking, continuous...

  • Answered by AI
  • Q2. In-depth technical interview which went around 40 min. since i had 8 years of experience
  • Q3. Fully technical
  • Q4. Salary discussion and Document verification.

Interview Preparation Tips

Round: Resume Shortlist
Experience: Keywords that I put in of the technology, tools , experience.. (I guess )

General Tips: Just stay calm. Do not show fake experience, Speak genuinely, Answer to the point and explain if you have to add on more depending on your experience. Do not be over confident. Speak start to the eyes
Skills: Communication, Problem Solving, Analytical Skills, Leadership, Presentation Skills, Decision Making Skills
Duration: 1-3 Months

Interview Preparation Tips

Round: Technical Interview
Experience: Has a 1 hr interview. He asked the Qs on my experience, what I have put in my resume. Its good conversation with interviewer.

Round: HR Interview
Experience: In HR interview he asked about my salary and what he is going to offer me. I left for the day. There is no response for 5 days from the HR. After a week I got the call my HR and discussion was happened about the salary again and said to upload some documents. I did it. There is no response for 4 days again. I got call again after 4 days and this time she said there is no suitable position for my experience so she is going to reject my application. Its very painful to listen like this.

I applied via Recruitment Consultant and was interviewed in Jul 2018. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. What is the biggest challenge you faced in developing azure solution?
  • Ans. 

    The biggest challenge in developing Azure solution was managing the complexity of the cloud environment.

    • Managing the complexity of the cloud environment

    • Ensuring scalability and reliability

    • Integrating with existing systems

    • Securing the solution

    • Optimizing cost

    • Example: Migrating a legacy application to Azure

  • Answered by AI
  • Q2. In azure data factory how would you implement the functionality of tumbling window without actually using that feature already available?
  • Ans. 

    Implementing tumbling window in Azure Data Factory without using the feature

    • Create a pipeline with a trigger that runs at the desired interval

    • Use a lookup activity to retrieve the data for the current window

    • Use a foreach activity to iterate over the retrieved data

    • Perform the required operations on the data within the foreach activity

    • Write the output to the desired destination

  • Answered by AI
  • Q3. What would be your suggestion for implementation in azure data factory v2?
  • Ans. 

    My suggestion for implementation in Azure Data Factory v2 is to use the Mapping Data Flow feature.

    • Utilize Mapping Data Flow for complex data transformations

    • Take advantage of the visual interface to design and debug data flows

    • Leverage the built-in data integration capabilities with other Azure services

    • Use data flow parameters and expressions for dynamic transformations

    • Monitor and optimize data flow performance using dat

  • Answered by AI
  • Q4. I was given a project scenario and was requested to choose from below cluster or cluster less , hive or u-sql?

Interview Preparation Tips

General Tips: Be pretty confident on the current project you are working on. It's ok that you do not know the complete technology but you should have the complete picture of stuff you are working on. Be clear as to why are using specific technology for your project and not the other one. For example, i worked on azure and drilled my way to understand the edge azure has over aws. I did good work onto why are we using hive language and azure data ware house for our project instead of using u-sql and azure SQL data base. Do not bluff, better be humble to accept that we are not fully aware of something and given a chance to work on, we will. And last thing, smile and appreciate the effort put in by interviewer.
Skills: Coding Skills, Datawarehousing, Azure data factory, Problem Solving, Analytical Skills
Duration: <1 week

Skills evaluated in this interview

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

Interview Questionnaire 

2 Questions

  • Q1. What is C++
  • Ans. 

    C++ is a high-level programming language used for developing system software, application software, device drivers, and video games.

    • C++ is an extension of the C programming language.

    • It supports object-oriented programming concepts like classes, inheritance, polymorphism, and encapsulation.

    • C++ is used in developing operating systems, browsers, databases, and other software applications.

    • It is known for its performance an...

  • Answered by AI
  • Q2. What is Link List
  • Ans. 

    A data structure that stores a sequence of elements in a linear order.

    • Consists of nodes that contain data and a pointer to the next node.

    • Can be singly linked or doubly linked.

    • Used for implementing stacks, queues, and hash tables.

    • Example: Singly linked list - 1 -> 2 -> 3 -> null

    • Example: Doubly linked list - null <- 1 <-> 2 <-> 3 -> null

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't go

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Technical stuff from SDH,MPLS,VLAN,IP tables etc
  • Q2. Under which principle does VLAN work?
  • Ans. 

    VLAN works under the principle of network segmentation.

    • VLAN separates a physical network into multiple logical networks.

    • It improves network performance, security, and management.

    • VLAN tags packets with a unique identifier to identify the network they belong to.

    • Example: VLAN can be used to separate guest and employee networks in a company.

  • Answered by AI
  • Q3. What is current CTC and expected CTC
  • Ans. 

    The question asks about the candidate's current and expected salary.

    • Be honest and transparent about your current salary.

    • Research the market rates for your role and level of experience to determine a reasonable expected salary.

    • Consider other benefits and perks besides the base salary.

    • Avoid discussing salary expectations too early in the interview process.

    • Focus on the value you can bring to the company rather than just t

  • Answered by AI

Skills evaluated in this interview

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

Interview Questionnaire 

2 Questions

  • Q1. Why are you looking for the job change?
  • Q2. Relevant technical questions, as per my current technology

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it simple and be yourself. That's what the interviewers looked into. Also a thorough understanding of the technology is a must and that is what will help you in cracking the interview. You don't have to go in-depth, just the overview and what happens when is what they look for. Good communication skills is also an added incentive, something I always try to work on. All the best

I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. We were asked to make a hotel booking app in reactjs.
  • Ans. 

    To make a hotel booking app in ReactJS

    • Create a form to input booking details

    • Use a calendar component to select dates

    • Display available rooms and prices

    • Implement payment gateway

    • Include user authentication and booking history

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I got the job by winning third place at a women's hackathon which was held at hcl technologies. Practice building an app on your own and use routing and material ui components.

I applied via Recruitment Consultant and was interviewed in Mar 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Interview was easy with basic questions from Appian . Read the basic things about process models report basic of integration, you're good to go

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be calm and try to answer everything.

TCS Interview FAQs

How many rounds are there in TCS Oracle Application Database Administrator 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 Database Administrator 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 Dba, Oracle E - business Suite, Oracle Apps, Apps DBA and Database Administration.
What are the top questions asked in TCS Oracle Application Database Administrator interview?

Some of the top questions asked at the TCS Oracle Application Database Administrator interview -

  1. in RAC database 2 nodes are there how you will re-direct users to 2nd node on...read more
  2. what is Oracle Block Cha...read more
  3. OEM services-related Questi...read more

Tell us how to improve this page.

TCS Oracle Application Database Administrator Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
View all
TCS Oracle Application Database Administrator Salary
based on 103 salaries
₹3.4 L/yr - ₹12 L/yr
23% less than the average Oracle Application Database Administrator Salary in India
View more details

TCS Oracle Application Database Administrator Reviews and Ratings

based on 4 reviews

5.0/5

Rating in categories

4.1

Skill development

4.6

Work-life balance

3.7

Salary

5.0

Job security

4.6

Company culture

4.3

Promotions

4.6

Work satisfaction

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

₹0 L/yr - ₹0 L/yr

IT Analyst
66.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AST Consultant
51.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
29.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
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