Upload Button Icon Add office photos

Genpact

Compare button icon Compare button icon Compare

Filter interviews by

Genpact Oracle Apps DBA Interview Questions and Answers for Experienced

Updated 4 Feb 2023

Genpact Oracle Apps DBA Interview Experiences for Experienced

1 interview found

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

I applied via Referral and was interviewed before Feb 2022. There were 4 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 - Technical 

(2 Questions)

  • Q1. How user login flow happens for ERP?
  • Ans. 

    User login flow for ERP involves authentication, authorization, and session management.

    • User enters credentials on login page

    • Credentials are verified against database

    • If credentials are valid, user is authenticated and authorized to access ERP modules

    • A session is created for the user

    • User can access ERP modules until session expires or user logs out

  • Answered by AI
  • Q2. Many online resources available. You can answer based on your understanding
Round 3 - Technical 

(2 Questions)

  • Q1. Can we apply ebs patches using adpatch in EBS 12.2?
  • Ans. 

    Yes, we can apply EBS patches using adpatch in EBS 12.2.

    • Adpatch is the standard utility for applying patches in EBS.

    • It can be used to apply patches to both the application and database tiers.

    • Adpatch can be run in interactive or non-interactive mode.

    • It is recommended to apply patches in a test environment before applying them in production.

    • Adpatch logs can be found in the $APPL_TOP/admin//log directory.

Answered by AI
  • Q2. No. EBS 12.2 supports only adop to apply patches
  • Ans. 

    Yes

    • EBS 12.2 supports the use of adop (Application DBA Online Patching) utility for applying patches

    • adop is a tool provided by Oracle for patching and maintaining Oracle E-Business Suite (EBS) environments

    • It allows for online patching, which means that patches can be applied while the system is still running

    • adop provides features like patching in parallel, patching multiple nodes simultaneously, and rolling back patches...

  • Answered by AI
    Round 4 - HR 

    (2 Questions)

    • Q1. What is your current CTC and Expected CTC?
    • Q2. This is personal to every one

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Get Package while joining itself. Yearly hikes are less than 10%
    Great work culture and team leads. Genpact having excellent DBA projects with latest technologies.

    Skills evaluated in this interview

    Interview questions from similar companies

    I applied via Referral and was interviewed before Dec 2019. There were 3 interview rounds.

    Interview Questionnaire 

    1 Question

    • Q1. About apps architecture closing patching rman utility and basic core architecture

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Prepare above if your going as a fresher or 1 year exp just be confident and one more imp thing english lang can be your benefit at the time of interview so be good with english communication skills as well
    Interview experience
    5
    Excellent
    Difficulty level
    -
    Process Duration
    -
    Result
    -
    Round 1 - Technical 

    (2 Questions)

    • Q1. How to add RAC node in19c DB?
    • Ans. 

      To add a RAC node in 19c DB, you need to run the 'addNode.sh' script on the new node.

      • Ensure the new node meets all the prerequisites for adding to the RAC cluster.

      • Run the 'addNode.sh' script on the new node to add it to the existing RAC cluster.

      • Verify the addition of the new node by checking the cluster status and resources.

    • Answered by AI
    • Q2. How to do troubleshoot EBS R12.2 Login issue?
    • Ans. 

      To troubleshoot EBS R12.2 login issue, check for incorrect login credentials, session timeout, browser cache, and server connectivity.

      • Verify the correctness of login credentials entered by the user.

      • Check for session timeout settings in EBS R12.2.

      • Clear browser cache and cookies to eliminate any login issues caused by stored data.

      • Ensure proper server connectivity to the EBS R12.2 instance.

    • Answered by AI

    Skills evaluated in this interview

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

    I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.

    Round 1 - Technical 

    (1 Question)

    • Q1. Roles and responsibilities of current company, What is difference between 12.1 and 12.2 application Adop patching Database patching Weblogic Performance tuning Clonning Backups Data Guard configurat...
    Interview experience
    5
    Excellent
    Difficulty level
    -
    Process Duration
    -
    Result
    -
    Round 1 - Technical 

    (2 Questions)

    • Q1. I were very happy with technical discussion with Infosys, and It went good.
    • Q2. I have faced lot of technical question regarding Oracle DBA, Oracle Apps DBA.

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

    Interview Questionnaire 

    6 Questions

    • Q1. What is the difference between UL and VUL
    • Ans. 

      UL and VUL are both types of life insurance policies, but VUL offers investment options while UL does not.

      • UL stands for Universal Life Insurance, which offers a fixed premium and death benefit but no investment options

      • VUL stands for Variable Universal Life Insurance, which offers investment options in addition to a flexible premium and death benefit

      • VUL policyholders can choose to invest in stocks, bonds, and mutual fun...

    • Answered by AI
    • Q2. What are the Death Benefit Options?
    • Q3. What are the Non-forfeiture options?
    • Ans. 

      Non-forfeiture options are the choices available to a policyholder when they stop paying premiums.

      • Non-forfeiture options allow policyholders to retain some value from their policy even if they stop paying premiums.

      • Common non-forfeiture options include reduced paid-up insurance, extended term insurance, and cash surrender value.

      • Reduced paid-up insurance provides a smaller death benefit but does not require further premi...

    • Answered by AI
    • Q4. What is Reinsurance?
    • Ans. 

      Reinsurance is a process where an insurance company transfers a portion of its risk to another insurance company.

      • Reinsurance helps insurance companies manage their risk exposure.

      • It allows insurance companies to protect themselves against large losses.

      • Reinsurance can be either proportional or non-proportional.

      • Proportional reinsurance involves sharing both premiums and losses with the reinsurer.

      • Non-proportional reinsuran...

    • Answered by AI
    • Q5. What is an Underwriting?
    • Ans. 

      Underwriting is the process of evaluating and assessing the risk of insuring a person or entity.

      • Underwriting involves analyzing the potential risks and determining the appropriate premium to charge for insurance coverage.

      • It is commonly used in the insurance industry for various types of insurance policies such as life, health, and property insurance.

      • Underwriting also involves reviewing the applicant's financial and med...

    • Answered by AI
    • Q6. Major differences between traditional life and whole life products?

    Interview Preparation Tips

    Interview preparation tips for other job seekers - If you are attending an interview for the Insurance project, you will face most of the questions from the Insurance domain. So please be prepared.

    Interview Questionnaire 

    1 Question

    • Q1. Why you want to leave company.

    I applied via LinkedIn and was interviewed before Jun 2021. There were 2 interview rounds.

    Round 1 - Group Discussion 

    They give some topics related to present situation like in my GD in 2020 co. HR give topics related to that situation in our country like difference between offline education and online education system. and covid-19 pandemic related topics.

    Round 2 - One-on-one 

    (4 Questions)

    • Q1. Tell me About your self ?
    • Q2. What do you know about this job position ?
    • Q3. What is your favourite colour ? Can i know the speciality of your favourite colour ?
    • Q4. Who inspired you to go to job daily and work hard ?

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Your 1st impression is your resume nothing else then after you have some knowledge about your job position which you apply for and most important if you want only private job your english language will be excellent spoken as well as written.

    Interview Questionnaire 

    1 Question

    • Q1. Questions related to COBOL,JCL,VSAM,DB2,CICS,Vision plus

    Interview Questionnaire 

    7 Questions

    • Q1. Solid principles
    • Q2. Extension methods
    • Q3. Static class and static constructor
    • Ans. 

      Static class and static constructor in C#

      • Static class can only contain static members and cannot be instantiated

      • Static constructor is called only once when the class is first accessed

      • Static constructor is used to initialize static members of the class

      • Example: Math class in C# is a static class

      • Example: static constructor can be used to initialize a static variable with a value

    • Answered by AI
    • Q4. Polymorphism
    • Q5. Dependency injection
    • Q6. Angular life cycle hook
    • Q7. Performance improvement in Angular app
    • Ans. 

      Performance improvement in Angular app

      • Use lazy loading to load modules on demand

      • Optimize change detection strategy

      • Use trackBy function in ngFor loops

      • Minimize DOM manipulation

      • Use AOT compilation

      • Implement server-side rendering

      • Use web workers for heavy computations

      • Use caching for frequently accessed data

    • Answered by AI

    Skills evaluated in this interview

    Genpact Interview FAQs

    How many rounds are there in Genpact Oracle Apps DBA interview for experienced candidates?
    Genpact interview process for experienced candidates usually has 4 rounds. The most common rounds in the Genpact interview process for experienced candidates are Technical, Resume Shortlist and HR.
    How to prepare for Genpact Oracle Apps DBA interview for experienced candidates?
    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 Apps DBA, CCTV Monitoring, Performance Tuning, WebLogic Administration and OEM.
    What are the top questions asked in Genpact Oracle Apps DBA interview for experienced candidates?

    Some of the top questions asked at the Genpact Oracle Apps DBA interview for experienced candidates -

    1. Can we apply ebs patches using adpatch in EBS 12...read more
    2. How user login flow happens for E...read more
    3. No. EBS 12.2 supports only adop to apply patc...read more

    Tell us how to improve this page.

    Genpact Oracle Apps DBA Interview Process for Experienced

    based on 1 interview

    Interview experience

    5
      
    Excellent
    View more

    Interview Questions from Similar Companies

    TCS Interview Questions
    3.7
     • 10.7k Interviews
    Accenture Interview Questions
    3.8
     • 8.3k Interviews
    Infosys Interview Questions
    3.6
     • 7.7k Interviews
    Wipro Interview Questions
    3.7
     • 5.7k Interviews
    Cognizant Interview Questions
    3.7
     • 5.7k Interviews
    Capgemini Interview Questions
    3.7
     • 4.9k Interviews
    HCLTech Interview Questions
    3.5
     • 3.9k Interviews
    Tech Mahindra Interview Questions
    3.5
     • 3.9k Interviews
    IBM Interview Questions
    4.0
     • 2.4k Interviews
    DXC Technology Interview Questions
    3.7
     • 805 Interviews
    View all
    Genpact Oracle Apps DBA Salary
    based on 12 salaries
    ₹5.4 L/yr - ₹14.5 L/yr
    10% more than the average Oracle Apps DBA Salary in India
    View more details

    Genpact Oracle Apps DBA Reviews and Ratings

    based on 3 reviews

    5.0/5

    Rating in categories

    5.0

    Skill development

    4.0

    Work-life balance

    2.2

    Salary

    4.5

    Job security

    4.0

    Company culture

    4.0

    Promotions

    5.0

    Work satisfaction

    Explore 3 Reviews and Ratings
    Process Developer
    36.6k salaries
    unlock blur

    ₹1.2 L/yr - ₹6.8 L/yr

    Process Associate
    28.1k salaries
    unlock blur

    ₹0.9 L/yr - ₹7 L/yr

    Assistant Manager
    20.4k salaries
    unlock blur

    ₹4 L/yr - ₹14.6 L/yr

    Management Trainee
    19.8k salaries
    unlock blur

    ₹1.6 L/yr - ₹11 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