Upload Button Icon Add office photos
Engaged Employer

i

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

IBM Verified Tick

Compare button icon Compare button icon Compare
4.0

based on 21.4k Reviews

Filter interviews by

IBM Oracle Application Technical Consultant Interview Questions and Answers

Updated 14 Apr 2023

IBM Oracle Application Technical Consultant Interview Experiences

1 interview found

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

I applied via Recruitment Consulltant and was interviewed before Apr 2022. 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 tips
Round 2 - Technical 

(1 Question)

  • Q1. What is cursor and its types
  • Ans. 

    A cursor is a database object used to manipulate data in a result set.

    • A cursor is used to retrieve data from a database one row at a time.

    • There are two types of cursors: implicit and explicit.

    • Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.

    • Examples of explicit cursors include FOR LOOP and OPEN-FOR-FETCH-CLOSE.

    • Cursors can be used to update, delete, or insert data i

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. What is the reason for job change

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How would you relate one value set with another one in oracle apps
  • Ans. 

    Value sets can be related in Oracle Apps by using cross validation rules.

    • Create cross validation rules to relate one value set with another

    • Define the conditions under which values from one value set can be used with values from another

    • Cross validation rules can be set up at the segment level in the value set definition

    • Example: Creating a cross validation rule to ensure that a specific department can only be associated

  • Answered by AI
  • Q2. How many type of report triggers are there
  • Ans. 

    There are 6 types of report triggers in Oracle Reports.

    • BEFORE REPORT trigger

    • AFTER REPORT trigger

    • BEFORE PARAMETER FORM trigger

    • AFTER PARAMETER FORM trigger

    • BEFORE REPORT BODY trigger

    • AFTER REPORT BODY trigger

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Oracle forms trigger
  • Q2. Report triggers and sequence
Interview experience
3
Average
Difficulty level
Hard
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Order management,interface, conversations, inbound,outbound,extension

Interview Preparation Tips

Topics to prepare for Genpact Oracle Application Technical Consultant interview:
  • Order Management
  • Accounts Payable
  • Accounts Receivable
  • SCM
  • Inventory
  • PLSQL
  • SQL
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
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 - One-on-one 

(1 Question)

  • Q1. Tell about yourself
  • Ans. 

    Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.

    • 5+ years of experience as an Oracle DBA

    • Proficient in database management, performance optimization, and data security

    • Skilled in troubleshooting and resolving database issues

    • Strong knowledge of Oracle database architecture and SQL

    • Certified Oracle Database Administrator (OCA/OCP)

  • Answered by AI
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
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Mainly they focus on PLSQL query .
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2023. 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 - HR 

(2 Questions)

  • Q1. HR round is the 1st round is like recuiter called u and ask some basic questons related to your profile
  • Q2. About Your profile
Round 3 - Technical 

(2 Questions)

  • Q1. 2nd round is like interview will be virtual and interviewer wil ask your previous work amd project related questions starts with basic and while your explaining your answer interviewer ask cross questons t...
  • Q2. 3rd round with the client Oracle, they asked questions related CoreHr position syncronization l, about HDL and Customization and about Security profiles and Payroll flow and Taxes for us legislation and so...
Round 4 - Behavioral 

(1 Question)

  • Q1. 3rd round is like discussion about scenarious of ur previously ur faced and they check ur knowledge if u suit the role or not

IBM Interview FAQs

How many rounds are there in IBM Oracle Application Technical Consultant interview?
IBM interview process usually has 3 rounds. The most common rounds in the IBM interview process are Resume Shortlist, Technical and HR.

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k 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.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
LTIMindtree Interview Questions
3.8
 • 3k Interviews
View all
IBM Oracle Application Technical Consultant Salary
based on 49 salaries
₹3.9 L/yr - ₹12.1 L/yr
11% less than the average Oracle Application Technical Consultant Salary in India
View more details

IBM Oracle Application Technical Consultant Reviews and Ratings

based on 8 reviews

4.8/5

Rating in categories

4.5

Skill development

4.9

Work-life balance

4.3

Salary

4.3

Job security

4.8

Company culture

3.1

Promotions

4.5

Work satisfaction

Explore 8 Reviews and Ratings
Application Developer
11.6k salaries
unlock blur

₹5.5 L/yr - ₹23.6 L/yr

Software Engineer
5.5k salaries
unlock blur

₹4.9 L/yr - ₹22.3 L/yr

Advisory System Analyst
5.2k salaries
unlock blur

₹9.2 L/yr - ₹27 L/yr

Senior Software Engineer
4.8k salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Senior Systems Engineer
4.6k salaries
unlock blur

₹5.6 L/yr - ₹19 L/yr

Explore more salaries
Compare IBM with

Oracle

3.7
Compare

TCS

3.7
Compare

Cognizant

3.8
Compare

Accenture

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