AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Genpact
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Genpact Oracle Database Administrator Interview Questions and Answers
Genpact Oracle Database Administrator Interview Experiences
2 interviews found
Anonymous
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...
- 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...
- Q3. Dataguard DR
Interview Preparation Tips
Madhu Josyula
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'
- 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
Interview Preparation Tips
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
Interview questions from similar companies
I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Self introduction
Interview Preparation Tips
I appeared for an interview before Dec 2020.
(1 Question)
Round duration - 45 minutes
Round difficulty - Hard
All mcqs should answer with in time limit should have a lot of practice to solve in exam
- Q1.
Water Jug Problem Statement
You have two water jugs with capacities
XandYliters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to... - Ans.
The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.
Start by considering the constraints and limitations of the problem.
Think about how the operations allowed can be used to reach the target measurement.
Consider different scenarios and test cases to come up with a solution.
Implement a function that takes the capacities of the jugs and the targe...
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
Easy and just basic questions very easy round
- Q1.
Matrix Multiplication Task
Given two sparse matrices
MAT1andMAT2of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl... - Ans.
Implement a function to multiply two sparse matrices and return the resulting matrix.
Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.
Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.
Ensure to handle the sparse nature of the matrices to optimize the multiplication process.
Consider the constraints provided to en...
Interview Preparation Tips
Tip 1 : preapre core subjects
Tip 2 : be confident and answer clearly
Tip 3 : be strong with projects
Tip 1 : good projects in ml and ai
Tip 2 : practical experience
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is flexbox
- Ans.
Flexbox is a CSS layout module that allows for flexible and responsive web design.
Flexbox allows for easy alignment and positioning of elements within a container.
It uses a set of properties to define the layout, such as display: flex and flex-direction.
Flexbox is particularly useful for creating responsive designs that adapt to different screen sizes.
It can also be used in combination with other CSS layout modules, su...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. It was for automotive domain. Mainly the questions were on automotive concept like CAN, UDS protocols, and tools of Vector company. Embedded c knowledge is must
- Q2. Embedded c knowledge is must
- Q3. Debugging skills are add on
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is a bit
- Q2. What us the size of a bit
- Ans.
A bit is the smallest unit of digital information. It can have a value of either 0 or 1.
A bit is a binary digit, represented as either 0 or 1.
It is the basic unit of information used in computing and digital communications.
A group of 8 bits is called a byte.
The size of a bit is dependent on the architecture of the computer system.
- Q3. How many bits are there in C
- Ans.
C is a programming language and does not have a fixed number of bits.
C is a high-level programming language that can be compiled to run on different architectures with varying bit sizes.
The number of bits in C depends on the hardware architecture it is compiled for.
For example, C code compiled for a 32-bit architecture will have 32-bit integers, while code compiled for a 64-bit architecture will have 64-bit integers.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic question on testing, selenium, java, sql, agile, topics from resume
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Apr 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. All technical discussion not much deeper but basic questions of graduation were asked
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Networking
Genpact Interview FAQs
Tell us how to improve this page.
Genpact Interviews By Designations
- Genpact Process Associate Interview Questions
- Genpact Process Developer Interview Questions
- Genpact Management Trainee Interview Questions
- Genpact Assistant Manager Interview Questions
- Genpact Senior Associate Interview Questions
- Genpact Business Analyst Interview Questions
- Genpact Consultant Interview Questions
- Genpact Accountant Interview Questions
- Show more
Interview Questions for Popular Designations
- Database Developer Interview Questions
- Oracle Application Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Oracle Apps DBA Interview Questions
- Senior Oracle Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Show more
Oracle Database Administrator Interview Questions from Similar Companies
Fast track your campus placements
Genpact Oracle Database Administrator Reviews and Ratings
based on 7 reviews
Rating in categories
|
Process Developer
36.6k
salaries
|  ₹1 L/yr - ₹6.8 L/yr |
|
Process Associate
28.1k
salaries
| ₹0.9 L/yr - ₹6.5 L/yr |
|
Assistant Manager
20.4k
salaries
| ₹4 L/yr - ₹14.6 L/yr |
|
Management Trainee
19.8k
salaries
| ₹1.6 L/yr - ₹11 L/yr |
|
Manager
7.5k
salaries
| ₹7 L/yr - ₹24 L/yr |
Accenture
Capgemini
TCS
Cognizant
- Home >
- Interviews >
- Genpact Interview Questions >
- Genpact Oracle Database Administrator Interview Questions
