Upload Button Icon Add office photos
Engaged Employer

i

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

DXC Technology Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

DXC Technology Oracle Database Administrator Interview Questions and Answers

Updated 19 Oct 2024

DXC Technology Oracle Database Administrator Interview Experiences

5 interviews found

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
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is the role of Oracle DBA
  • Ans. 

    The role of an Oracle DBA is to manage and maintain Oracle databases to ensure they are secure, efficient, and reliable.

    • Installing and upgrading Oracle software

    • Configuring and monitoring database performance

    • Backup and recovery of data

    • Troubleshooting and resolving database issues

    • Implementing security measures to protect data

    • Managing users and permissions

  • Answered by AI

Oracle Database Administrator Interview Questions Asked at Other Companies

asked in Wistron
Q1. how can you recover the deleted datafiles if datafiles are not ta ... read more
asked in Wipro
Q2. 19c upgradation steps Challanges faced during upgradation. Datagu ... read more
asked in Accenture
Q3. How would you monitor a db performance with OEM AWR report?
asked in Genpact
Q4. How to select a particular row from a table.
Q5. How oracle architecture is work. How to check if user password ex ... read more
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What is rac in brief
  • Ans. 

    RAC stands for Real Application Clusters, a feature of Oracle Database that allows multiple instances to access a single database simultaneously.

    • Enables high availability and scalability by distributing workload across multiple nodes

    • Provides failover protection and load balancing

    • Allows for parallel execution of queries across multiple nodes

    • Example: A company using RAC to ensure continuous availability of their critical

  • Answered by AI
  • Q2. What is data gurad
  • Ans. 

    Data Guard is Oracle's high availability and disaster recovery solution for Oracle databases.

    • Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.

    • It ensures high availability, data protection, and disaster recovery for enterprise data.

    • Data Guard can be used with traditi...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Why u want to switch
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for new challenges to enhance my skills

    • Interested in working with cutting-edge technology

    • Seeking opportunities for career growth and advancement

  • Answered by AI
  • Q2. What do u expect from new company
  • Ans. 

    I expect a supportive work environment, opportunities for growth, and a collaborative team.

    • Supportive work environment with open communication

    • Opportunities for professional growth and development

    • Collaborative team that values teamwork and diversity

  • Answered by AI

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Oct 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 - HR 

(2 Questions)

  • Q1. 1)Tell me about your self 2) Your educational background
  • Q2. 3) why it field 4) which certification you have
Round 3 - Aptitude Test 

Quants, logic and English including puzzles and some gk based puzzles as well

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool while interview don't get afraid they will hire you

DXC Technology interview questions for designations

 Associate Oracle Database Administrator

 (1)

 SQL Database Administrator

 (1)

 Cassandra Database Administrator

 (1)

 Database Administrator Professional 1

 (1)

 Database Administrator Professional 2

 (1)

 System Administrator

 (4)

 Vmware Administrator

 (3)

 Backup Administrator

 (2)

I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - Technical 

(1 Question)

  • Q1. You should be prepared with technical skills according to your college curricular
Round 3 - Coding Test 

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

Round 4 - HR 

(6 Questions)

  • Q1. What are your salary expectations?
  • Q2. Why should we hire you?
  • Q3. Where do you see yourself in 5 years?
  • Q4. What are your strengths and weaknesses?
  • Q5. Tell me about yourself.
  • 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

Interview Preparation Tips

Topics to prepare for DXC Technology Oracle Database Administrator interview:
  • C
  • Algorithms
  • Core Java
  • Java
  • DBMS
  • Data Structures
  • Database
  • SQL
Interview preparation tips for other job seekers - DXC is the environment where you can develop the skills in your first days of the career. I am very happy that i am sharing this experience
Few important things you need to be ready with:
1) You should be confident.
2) You should be a good communicator that helps good impression to the interviewer.
3) Command on the technical aspects
4) Make sure you update the resume with the skills you have good knowledge
5) Answer the interviewer with good smile and pleasent nature - dont be rude or don't look like ur not interested
6)When you don't know the answer just tell them you don't have idea about it and also mention you are a quick learner
7) Thank the interviewer at the end of the interview

#dxcian

Interview questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I was interviewed before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

  • Q1. 

    Find the Duplicate Number Problem Statement

    Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...

  • Ans. 

    Find the duplicate number in an array of integers from 0 to (N-2).

    • Iterate through the array and keep track of the frequency of each number using a hashmap.

    • Return the number with a frequency greater than 1 as the duplicate number.

    • Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...

  • Ans. 

    Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.

    • Iterate through the array of indices and reverse the substrings accordingly

    • Ensure the range specified by each index is non-empty

    • Return the final string after all operations are completed

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

DXC Technology Interview FAQs

How many rounds are there in DXC Technology Oracle Database Administrator interview?
DXC Technology interview process usually has 2-3 rounds. The most common rounds in the DXC Technology interview process are Technical, HR and Aptitude Test.
How to prepare for DXC Technology Oracle 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 DXC Technology. The most common topics and skills that interviewers at DXC Technology expect are Oracle DBA, Database Administration, RAC, RMAN and Performance Tuning.
What are the top questions asked in DXC Technology Oracle Database Administrator interview?

Some of the top questions asked at the DXC Technology Oracle Database Administrator interview -

  1. What is the role of Oracle ...read more
  2. What is rac in br...read more
  3. What is data gu...read more

Tell us how to improve this page.

DXC Technology Oracle Database Administrator Interview Process

based on 7 interviews

Interview experience

3.9
  
Good
View more
DXC Technology Oracle Database Administrator Salary
based on 333 salaries
₹2.8 L/yr - ₹9.8 L/yr
26% less than the average Oracle Database Administrator Salary in India
View more details

DXC Technology Oracle Database Administrator Reviews and Ratings

based on 42 reviews

3.8/5

Rating in categories

3.6

Skill development

4.0

Work-life balance

3.0

Salary

3.8

Job security

3.5

Company culture

2.9

Promotions

3.5

Work satisfaction

Explore 42 Reviews and Ratings
Associate Professional Software Engineer
2.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Professional
1.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Professional 1
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare DXC Technology with

Cognizant

3.7
Compare

Capgemini

3.7
Compare

TCS

3.7
Compare

Wipro

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