Upload Button Icon Add office photos

Filter interviews by

Kyoto Technologies Oracle Apps DBA Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

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.
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
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 experience
    3
    Average
    Difficulty level
    Moderate
    Process Duration
    2-4 weeks
    Result
    Not Selected

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

    Round 1 - Technical 

    (2 Questions)

    • Q1. Tell me the high level overview of dataguard installation?
    • Q2. What are your daily tasks adn what things you handel in your team?
    Interview experience
    5
    Excellent
    Difficulty level
    -
    Process Duration
    Less than 2 weeks
    Result
    Not Selected

    I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

    Round 1 - Technical 

    (1 Question)

    • Q1. What is pull request
    • Ans. 

      A pull request is a method of submitting contributions to a project on GitHub for review and merging.

      • Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

      • They allow developers to collaborate and discuss changes before merging them into the main branch.

      • Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

      • Rev...

    • Answered by AI
    Round 2 - Technical 

    (1 Question)

    • Q1. What is sateful set
    • Ans. 

      Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.

      • Stateful set ensures that each pod in the set has a unique identity and stable network identity.

      • Stateful set pods are created in order and are not replaced until they are deleted.

      • Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

      • Example:...

    • Answered by AI

    Skills evaluated in this interview

    Interview experience
    3
    Average
    Difficulty level
    Moderate
    Process Duration
    Less than 2 weeks
    Result
    No response

    I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.

    Round 1 - Technical 

    (4 Questions)

    • Q1. Start up parameters of sql server
    • Ans. 

      Start up parameters are used to configure the behavior of SQL Server when it starts up.

      • Start up parameters are specified in the SQL Server Configuration Manager.

      • Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

      • Start up parameters can be modified to customize the behavior of SQL Server during startup.

      • Example: -dC:\Program Files\Microso...

    • Answered by AI
    • Q2. Differential backup query
    • Q3. Sql server statics
    • Q4. Log file architecture

    Interview Preparation Tips

    Interview preparation tips for other job seekers - kindly prepare all the topics about sql server.

    Skills evaluated in this interview

    Interview experience
    4
    Good
    Difficulty level
    Moderate
    Process Duration
    Less than 2 weeks
    Result
    Not Selected

    I was interviewed in Feb 2024.

    Round 1 - One-on-one 

    (2 Questions)

    • Q1. How to Migrate to AWS
    • Ans. 

      Migrating to AWS involves planning, preparation, and execution of a structured migration strategy.

      • Assess current infrastructure and applications to determine compatibility with AWS

      • Create a detailed migration plan outlining timelines, resources, and dependencies

      • Use AWS Migration Hub to track the progress of migration

      • Utilize AWS Database Migration Service for database migration

      • Consider using AWS Server Migration Service ...

    • Answered by AI
    • Q2. Ho to migrate to Azure
    • Ans. 

      Migrating to Azure involves planning, assessment, preparation, migration, and post-migration tasks.

      • Assess current infrastructure and applications for compatibility with Azure

      • Plan the migration strategy including timelines, resources, and potential challenges

      • Prepare by setting up Azure environment, configuring networking, and ensuring data security

      • Migrate data and applications using tools like Azure Site Recovery or Azu...

    • Answered by AI

    Skills evaluated in this interview

    Interview experience
    4
    Good
    Difficulty level
    -
    Process Duration
    -
    Result
    -
    Round 1 - HR 

    (2 Questions)

    • Q1. Why this company
    • Ans. 

      I am impressed by the company's innovative technology solutions and strong reputation in the industry.

      • The company has a track record of developing cutting-edge technology solutions.

      • I admire the company's commitment to excellence and continuous improvement.

      • The company's reputation for providing top-notch training and development opportunities is appealing to me.

    • Answered by AI
    • Q2. What salary do you expect
    • Ans. 

      I expect a competitive salary based on my experience, skills, and the market rate for Oracle Database Administrators.

      • Research the average salary range for Oracle Database Administrators in your area

      • Consider your level of experience and skills when determining your salary expectations

      • Be prepared to negotiate based on the specific responsibilities and benefits offered by the employer

    • Answered by AI

    Interview Preparation Tips

    Interview preparation tips for other job seekers - All the best
    Interview experience
    5
    Excellent
    Difficulty level
    -
    Process Duration
    -
    Result
    -
    Round 1 - Technical 

    (2 Questions)

    • Q1. Tell me something about yourself
    • Q2. What is your current ctc

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Na

    Tell us how to improve this page.

    Interview Questions from Similar Companies

    TCS Interview Questions
    3.7
     • 10.4k Interviews
    Accenture Interview Questions
    3.9
     • 8.1k Interviews
    Infosys Interview Questions
    3.7
     • 7.6k Interviews
    Wipro Interview Questions
    3.7
     • 5.6k Interviews
    Cognizant Interview Questions
    3.8
     • 5.6k Interviews
    Amazon Interview Questions
    4.1
     • 5k Interviews
    Capgemini Interview Questions
    3.8
     • 4.8k Interviews
    Tech Mahindra Interview Questions
    3.5
     • 3.8k Interviews
    HCLTech Interview Questions
    3.5
     • 3.8k Interviews
    Genpact Interview Questions
    3.9
     • 3k Interviews
    View all
    Business Operations Manager
    3 salaries
    unlock blur

    ₹5 L/yr - ₹5 L/yr

    Explore more salaries
    Compare Kyoto Technologies with

    TCS

    3.7
    Compare

    Infosys

    3.7
    Compare

    Wipro

    3.7
    Compare

    HCLTech

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