Premium Employer

i

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

Infosys Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Infosys Oracle Database Administrator Interview Questions, Process, and Tips

Updated 28 Oct 2024

Top Infosys Oracle Database Administrator Interview Questions and Answers

View all 13 questions

Infosys Oracle Database Administrator Interview Experiences

7 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is dba, explain the architecture of dba
  • Ans. 

    DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.

    • DBA is responsible for installing, configuring, and upgrading database software.

    • They monitor database performance and troubleshoot issues.

    • DBA designs and implements backup and recovery strategies to prevent data loss.

    • They also manage user access and security permissions within...

  • Answered by AI
  • Q2. How you will maintain the database and what are the types of backup
  • Ans. 

    Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.

    • Regularly monitor database performance and usage

    • Perform routine maintenance tasks such as applying patches and updates

    • Take regular backups to ensure data integrity and disaster recovery

    • Implement security measures to protect the database from unauthorized access

    • Optimize database performanc

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. What do you mean by lean supply chain
  • Ans. 

    A lean supply chain focuses on minimizing waste and maximizing efficiency in the flow of goods and services.

    • Focuses on reducing waste in all aspects of the supply chain

    • Emphasizes efficiency in production, transportation, and distribution

    • Involves continuous improvement and optimization of processes

    • Utilizes tools like Just-In-Time inventory management and Kanban systems

    • Examples include Toyota's production system and Dell

  • Answered by AI
  • Q2. What is Kaizen and Kanban
  • Ans. 

    Kaizen is a Japanese business philosophy of continuous improvement, while Kanban is a scheduling system for lean manufacturing.

    • Kaizen focuses on making small, incremental improvements in processes and systems.

    • Kaizen involves all employees in the organization and encourages suggestions for improvement.

    • Kanban is a visual scheduling system that helps manage workflow by limiting work in progress.

    • Kanban uses cards or signal...

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

I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. RAC components, backup scenarios, cache fusion ohasd background process, dataguard
Round 3 - HR 

(1 Question)

  • Q1. Work experience previous project details
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is config file
  • Ans. 

    A config file is a file that contains configuration settings for a software application or system.

    • Config files are used to store parameters and settings that determine the behavior of an application or system.

    • They are typically written in plain text format and can be edited using a text editor.

    • Config files are often used to specify database connection details, server settings, application preferences, etc.

    • Examples of c...

  • Answered by AI
  • Q2. What is RAC DBA
  • Ans. 

    RAC DBA stands for Real Application Clusters Database Administrator. It is responsible for managing Oracle databases that are part of a cluster.

    • RAC DBA manages Oracle databases that are part of a cluster

    • It involves configuring and maintaining the cluster infrastructure

    • Ensures high availability and scalability of the database

    • Performs tasks like installation, patching, backup, and recovery in a clustered environment

  • Answered by AI

Skills evaluated in this interview

Infosys interview questions for designations

 SQL Database Administrator

 (2)

 SQL Server Database Administrator

 (4)

 Database Administrator DBA

 (1)

 Oracle Developer

 (2)

 Database Consultant

 (1)

 Database Developer

 (1)

 Oracle Technical Consultant

 (1)

 Oracle Apps DBA

 (1)

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

I applied via Company Website and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are background processes?
  • Ans. 

    Background processes are processes that run in the background of an operating system without direct user interaction.

    • Background processes in Oracle Database include PMON, SMON, DBW0, LGWR, CKPT, and others.

    • These processes perform tasks such as managing memory, writing data to disk, and ensuring data consistency.

    • They help in maintaining the integrity and performance of the database system.

    • Background processes are essent...

  • Answered by AI
  • Q2. What is DBWR and LGWR?
  • Ans. 

    DBWR stands for Database Writer and LGWR stands for Log Writer in Oracle Database.

    • DBWR writes modified data blocks from the database buffer cache to the data files on disk.

    • LGWR writes redo log entries from the redo log buffer to the redo log files on disk.

    • DBWR and LGWR are background processes in Oracle Database responsible for ensuring data integrity and consistency.

    • DBWR and LGWR work together to ensure that changes m...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. What's difference between database and instance?
  • Ans. 

    A database is a collection of related data, while an instance is the set of memory structures and background processes used to access the database.

    • Database is the physical or logical container for data, while instance is the set of processes and memory structures used to access the database.

    • Multiple instances can access the same database, but each instance has its own memory and processes.

    • Database is persistent, while ...

  • Answered by AI
  • Q2. What's is LGWR?
  • Ans. 

    LGWR stands for Log Writer and is a background process in Oracle database responsible for writing redo log entries to disk.

    • LGWR ensures that changes made to the database are recorded in the redo log files before committing transactions.

    • It plays a crucial role in ensuring data integrity and crash recovery.

    • LGWR writes redo log entries from the log buffer to the redo log files on disk.

    • It operates continuously in the backg...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Skills evaluated in this interview

Get interview-ready with Top Infosys Interview Questions

Interview Questionnaire 

1 Question

  • Q1. What is dba? Roles and responsibilities and what kind of shift model
  • Ans. 

    A DBA is a database administrator who is responsible for managing and maintaining a company's database system.

    • Roles include database design, security, backup and recovery, performance tuning, and troubleshooting

    • Responsibilities include ensuring data integrity, availability, and accessibility

    • Shift models vary depending on the company's needs, but may include on-call availability and rotating shifts

    • Examples of database s

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good and normal Interview process. Cool process

Oracle Database Administrator Jobs at Infosys

View all

I applied via Recruitment Consulltant and was interviewed before Oct 2021. 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 Resume tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Control file multiplexing steps
  • Ans. 

    Control file multiplexing is the process of creating multiple copies of control files to ensure data redundancy.

    • Create additional copies of control files using the ALTER DATABASE statement

    • Specify the location and name of the additional control files

    • Ensure that all control files are accessible and synchronized

    • Monitor the alert log for any errors related to control files

  • Answered by AI
  • Q2. Data configuration steps
  • Ans. 

    Data configuration steps involve setting up and organizing data for efficient use.

    • Identify data sources and types

    • Determine storage requirements and allocate resources

    • Define data access and security policies

    • Configure backup and recovery procedures

    • Test and validate data configuration

  • Answered by AI
  • Q3. SQL tuning trouble shooting
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and joining date

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't loose hope & keep trying.
Keep practicing to enhance your skills & try to learn from mistakes, Every day you will learn something new.

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

College Name: Vidyalankar Institute Of Technology

Interview Questionnaire 

11 Questions

  • Q1. Hobbies: Drawing. Asked about drawing and pencil shading. Draw in next 5 mins something great to impress me else rejected
  • Q2. Sketch my face
  • Q3. If you are told to do a job of a peon for the company will you?
  • Q4. Remove all the pcs from the lab and keep in other lab RIGHT NOW?
  • Ans. 

    Yes, I can remove all the pcs from the lab and keep them in another lab right now.

    • Ensure all the necessary equipment and tools are available for the move

    • Coordinate with the lab staff to ensure a smooth transition

    • Label and document each PC for easy identification and setup in the new lab

    • Ensure proper packaging and handling to prevent any damage during the move

  • Answered by AI
  • Q5. Impress me with your talents
  • Q6. If a person asks you on a construction site to pick up bricks will you?
  • Q7. How crazy are you?
  • Q8. Show me how crazy are you in next 5 mins?
  • Q9. Write down Fibonacci series and also explain pseudo code for it?
  • Ans. 

    Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

    • The first two numbers of the series are always 0 and 1

    • The next number is the sum of the previous two numbers

    • The series goes on infinitely: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...

    • Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Pr

  • Answered by AI
  • Q10. Write algorithm for matrix multiplication?
  • Ans. 

    Algorithm for matrix multiplication

    • Create a result matrix with dimensions of the two input matrices

    • Iterate through each row and column of the result matrix

    • For each element in the result matrix, multiply corresponding row in first matrix with corresponding column in second matrix

    • Add the products obtained in the previous step to get the final value for the element

  • Answered by AI
  • Q11. Explain your project and which algorithm you used in it. Why that algorithm?
  • Ans. 

    I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.

    • The project involved collecting customer reviews from various sources.

    • Preprocessing the data by removing stop words, stemming, and tokenizing.

    • Used Naive Bayes algorithm for sentiment analysis.

    • The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.

    • The accuracy of the model was

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: Confused

If they say do you have any questions?
NEVER ASK about your performance in that round.

Round: Technical Interview
Experience: Good
Tips: Interview depends on your basic knowledge

Skills: Presence Of Mind, Technical Skills, Analytical Skills
College Name: Vidyalankar Institute Of Technology
Motivation: Got rejected for TCS aptitude.
Funny Moments: Whole HR interview

Skills evaluated in this interview

Interview Questionnaire 

9 Questions

  • Q1. Talk about your BE project?
  • Ans. 

    Developed a web-based project management system for a construction company.

    • Used PHP and MySQL for backend development

    • Implemented user authentication and authorization

    • Designed a responsive UI using Bootstrap

    • Integrated Google Maps API for location tracking

    • Enabled file uploads and downloads for project documents

  • Answered by AI
  • Q2. If you belong to EXTC, then why IT?
  • Ans. 

    EXTC and IT are not mutually exclusive fields. My knowledge in EXTC complements my skills in IT.

    • My knowledge in EXTC gives me a strong foundation in electronics and communication, which are essential in the IT industry.

    • I have also gained programming skills through my coursework and projects in EXTC.

    • IT is a rapidly growing field with a lot of opportunities, and I believe my skills and knowledge make me a strong candidat...

  • Answered by AI
  • Q3. Are you ok with relocation?
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for a position that aligns with my career goals

    • I am excited about the prospect of exploring a new city and culture

    • I am flexible and adaptable to new environments

  • Answered by AI
  • Q4. Which languages are you familiar with?
  • Ans. 

    I am familiar with several programming languages.

    • Java

    • Python

    • C++

    • JavaScript

    • SQL

  • Answered by AI
  • Q5. BE project members and your guide
  • Q6. What/s the diffrencebetween leader and a manager
  • Ans. 

    A leader inspires and motivates while a manager plans and organizes.

    • Leaders focus on the big picture while managers focus on details

    • Leaders lead by example while managers delegate tasks

    • Leaders inspire and motivate while managers enforce rules and policies

    • Leaders are visionaries while managers are implementers

    • Examples of leaders: Steve Jobs, Martin Luther King Jr. Examples of managers: Tim Cook, COO of Apple

  • Answered by AI
  • Q7. Are you okay with relocation?
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for the right job opportunity

    • I am open to exploring new places and cultures

    • I understand that relocation may come with challenges, but I am prepared to face them

    • I am excited about the prospect of starting fresh in a new location

  • Answered by AI
  • Q8. What's the name of the person who took your technical interview?
  • Ans. 

    I'm sorry, I don't have that information.

    • N/A

  • Answered by AI
  • Q9. How was the TCS aptitude test?
  • Ans. 

    The TCS aptitude test was challenging but fair.

    • The test covered a wide range of topics including math, logic, and English.

    • The questions were designed to test problem-solving skills and critical thinking.

    • Time management was crucial as there were many questions to answer in a limited time.

    • Overall, the test was a good indicator of one's aptitude for software engineering.

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: pretty decent and interactive
Tips: be true, be yourself

General Tips: Do not fake a personality, be original. Avoid an answer if you have to, but , in an affirmative way.
Skills: Ability To Justify, Ability To Be Involved In Hands On Work, Ability To Deal Diplomatically, Ability To Convince
College Name: Vidyalankar Institute Of Technology
Funny Moments: The HR interviewer asked me the name of my tech interviewer.
Contribute & help others!
anonymous
You can choose to be anonymous

Infosys Interview FAQs

How many rounds are there in Infosys Oracle Database Administrator interview?
Infosys interview process usually has 1-2 rounds. The most common rounds in the Infosys interview process are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Infosys 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 Infosys. The most common topics and skills that interviewers at Infosys expect are Oracle DBA, Database Administration, Oracle, Data Management and Oracle Database.
What are the top questions asked in Infosys Oracle Database Administrator interview?

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

  1. What is dba? Roles and responsibilities and what kind of shift mo...read more
  2. How you will maintain the database and what are the types of bac...read more
  3. What's difference between database and instan...read more

Recently Viewed

REVIEWS

Bright Vision

4.7

(3 reviews)

LIST OF COMPANIES

Bright Vision

Overview

REVIEWS

S&P Global

No Reviews

SALARIES

Infosys

REVIEWS

S&P Global

No Reviews

REVIEWS

S&P Global

No Reviews

JOBS

PrimEra Medical Technologies

No Jobs

SALARIES

Access Healthcare

REVIEWS

S&P Global

No Reviews

REVIEWS

S&P Global

No Reviews

Tell us how to improve this page.

Infosys Oracle Database Administrator Interview Process

based on 6 interviews

1 Interview rounds

  • Technical Round
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys Oracle Database Administrator Salary
based on 415 salaries
₹3.2 L/yr - ₹14.2 L/yr
At par with the average Oracle Database Administrator Salary in India
View more details

Infosys Oracle Database Administrator Reviews and Ratings

based on 15 reviews

3.7/5

Rating in categories

3.3

Skill development

3.6

Work-life balance

2.7

Salary

4.0

Job security

3.6

Company culture

2.9

Promotions

3.2

Work satisfaction

Explore 15 Reviews and Ratings
Oracle Database Administrator - oracle patching

Hyderabad / Secunderabad,

Chennai

+1

5-9 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
55.3k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
50.7k salaries
unlock blur

₹2.8 L/yr - ₹7.8 L/yr

System Engineer
39.6k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.9k salaries
unlock blur

₹5.1 L/yr - ₹19.6 L/yr

Senior Associate Consultant
28.2k salaries
unlock blur

₹6.2 L/yr - ₹16.6 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

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