Upload Button Icon Add office photos

Genpact

Compare button icon Compare button icon Compare

Filter interviews by

Genpact Oracle Database Administrator Interview Questions and Answers

Updated 12 Jan 2022

Genpact Oracle Database Administrator Interview Experiences

2 interviews found

I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. What is ckpt
  • Ans. 

    CKPT stands for Checkpoint. It is a background process in Oracle database that ensures data integrity and recovery.

    • CKPT is responsible for writing dirty buffers from the database buffer cache to the data files

    • It updates the control file and data file headers to record the most recent checkpoint

    • CKPT is triggered by various events like log switch, manual checkpoint, or when the dirty buffers reach a certain threshold

    • It h...

  • Answered by AI
  • Q2. What is redolog
  • Ans. 

    Redo log is a set of files that records all changes made to a database and is used for recovery and replication.

    • Redo log is a crucial component of Oracle database architecture.

    • It consists of two or more pre-allocated files that store all changes made to the database.

    • Redo log files are used for recovery in case of a system failure or crash.

    • They are also used for replication to maintain consistency across multiple databa...

  • Answered by AI
  • Q3. Dataguard DR

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well it's easy to clear

I applied via Recruitment Consultant and was interviewed before Oct 2017. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. It was very interesting round. They tested my technical knowledge in SQL. And they got convinced with my answers and got promoted for hr round.
  • Q2. How to select a particular row from a table.
  • Ans. 

    To select a particular row from a table, use the SELECT statement with a WHERE clause specifying the desired criteria.

    • Use the SELECT statement to query the table

    • Add a WHERE clause to specify the criteria for selecting the row

    • The WHERE clause can include conditions based on column values

    • Example: SELECT * FROM table_name WHERE column_name = 'desired_value'

  • Answered by AI
  • Q3. This round was very easy for me and spoke very comfortably with the interviewer. He got pleased with my answers.
  • Q4. Why did your father retire voluntarily?
  • Ans. 

    My father retired voluntarily to spend more time with his family and pursue his hobbies.

    • He wanted to focus on spending quality time with his family after years of working

    • He had interests and hobbies he wanted to pursue in his retirement

    • He felt it was the right time in his life to step back from work and enjoy his free time

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Sorry I don't remember. Might be aptitude

General Tips: It was a pleasant and memorable experience for me with Genpact. They were very cool. If the interviewer talks cool, we can also be comfortable with them and answer the questions in a better way.
Skills: Communication
Duration: 1-4 weeks

Skills evaluated in this interview

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 questions from similar companies

I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. They asked about dbms questions in the form of table formate
  • Q2. They asked code for some python program

Interview Preparation Tips

Interview preparation tips for other job seekers - Firstly they conducted computer based technical exam and then after qualifying that then we will go for face face interview and then lastly HR round will be held.

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Duration of the project and team environment

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with latest technologies.

I applied via LinkedIn and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1. tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - It was nice, but since Im not great at coding I didn't do well

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

Round 1 - Aptitude Test 

It includes, maths, English, Computer, general knowledge

Round 2 - Technical 

(1 Question)

  • Q1. Related to your field
Round 3 - HR 

(1 Question)

  • Q1. Communication skill and salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Just good with your knowledge and communication should be perfect.

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

Interview Questionnaire 

4 Questions

  • Q1. Was interviewed as fresher?
  • Q2. Written test conducted? with verbal ability test ? GD
  • Q3. How would u deal with a problematic situation when you are working in a team?
  • Q4. What are your plans about higher studies?

Interview Preparation Tips

Interview preparation tips for other job seekers - it was basic with apptiude test and attitiude test.

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

Interview Questionnaire 

3 Questions

  • Q1. Networking layers
  • Q2. Method over loading
  • Ans. 

    Method overloading is a feature in OOP where multiple methods can have the same name but different parameters.

    • Method overloading is used to improve code readability and reusability.

    • The methods must have different parameters, either in number or type.

    • Example: void print(int num), void print(String str), void print(int num1, int num2)

    • Method overloading is resolved at compile-time based on the number and type of arguments

  • Answered by AI
  • Q3. What is class
  • Ans. 

    A class is a blueprint for creating objects that have similar attributes and behaviors.

    • A class is a user-defined data type that encapsulates data and functions.

    • It provides a way to organize and structure code.

    • Objects are instances of a class.

    • Classes can inherit properties and methods from other classes.

    • Examples of classes in programming languages include String, Integer, and List.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I have attend Dxc technology as a fresher( off campus drive )

1) online aptitude question
2 ) technical Round ( face to face )
3) HR round

I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. String manipulation , collections, framework understanding

Interview Preparation Tips

Interview preparation tips for other job seekers - For QA Automation - Basics of OOPS concept,collections,strings are enough

I applied via Campus Placement and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What is sql
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases.

    • SQL stands for Structured Query Language

    • It is used to create, modify, and query databases

    • Common commands include SELECT, INSERT, UPDATE, and DELETE

    • SQL is used in a variety of industries, including finance, healthcare, and e-commerce

  • Answered by AI
  • Q2. What is dbms
  • Ans. 

    DBMS stands for Database Management System. It is a software system that allows users to define, create, maintain and control access to databases.

    • DBMS is used to manage large amounts of data efficiently.

    • It provides a way to store, retrieve and manipulate data in a structured way.

    • Examples of DBMS include MySQL, Oracle, and Microsoft SQL Server.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - good overall

Skills evaluated in this interview

Genpact Interview FAQs

How to prepare for Genpact 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 Genpact. The most common topics and skills that interviewers at Genpact expect are Oracle DBA, Oracle RAC, Patching, RAC and RMAN.
What are the top questions asked in Genpact Oracle Database Administrator interview?

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

  1. How to select a particular row from a tab...read more
  2. What is c...read more
  3. What is redo...read more

Tell us how to improve this page.

Genpact Oracle Database Administrator Salary
based on 90 salaries
₹3.1 L/yr - ₹13.1 L/yr
At par with the average Oracle Database Administrator Salary in India
View more details

Genpact Oracle Database Administrator Reviews and Ratings

based on 7 reviews

4.6/5

Rating in categories

4.6

Skill development

4.3

Work-life balance

3.9

Salary

4.5

Job security

4.2

Company culture

3.9

Promotions

4.3

Work satisfaction

Explore 7 Reviews and Ratings
Process Developer
36.5k salaries
unlock blur

₹1 L/yr - ₹7 L/yr

Process Associate
28.1k salaries
unlock blur

₹0.9 L/yr - ₹7 L/yr

Assistant Manager
20.3k salaries
unlock blur

₹4 L/yr - ₹14.6 L/yr

Management Trainee
19.7k salaries
unlock blur

₹1.6 L/yr - ₹8.5 L/yr

Manager
7.5k salaries
unlock blur

₹7 L/yr - ₹24 L/yr

Explore more salaries
Compare Genpact with

Accenture

3.8
Compare

Capgemini

3.7
Compare

TCS

3.7
Compare

Cognizant

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