Upload Button Icon Add office photos

Filter interviews by

AppSys Global Oracle Technical Consultant Interview Questions and Answers

Updated 18 Dec 2024

AppSys Global Oracle 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 LinkedIn and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the key features of Oracle Fusion BI reports?
  • Ans. 

    Key features of Oracle Fusion BI reports include interactive dashboards, ad-hoc analysis, and mobile access.

    • Interactive dashboards allow users to visualize data in real-time and make data-driven decisions.

    • Ad-hoc analysis enables users to create custom reports and explore data in a self-service manner.

    • Mobile access allows users to access reports on-the-go from any device.

    • Integration with other Oracle applications such a...

  • Answered by AI
  • Q2. Questions about previous work experience in OIC , Web services, SQL

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. SAP HANA Upgrade Steps
  • Ans. 

    SAP HANA upgrade steps involve planning, preparation, execution, and post-upgrade activities.

    • Perform system backup before starting the upgrade process.

    • Review SAP HANA upgrade guide for specific version requirements.

    • Check hardware and software compatibility for the new version.

    • Execute the upgrade using SAP HANA Lifecycle Manager (HDBLCM).

    • Perform post-upgrade tasks such as testing and validation of the upgraded system.

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. SAP HANA Migration Steps
  • Ans. 

    SAP HANA migration involves planning, preparation, migration, and post-migration activities.

    • Plan the migration by assessing current landscape and defining migration strategy.

    • Prepare by ensuring system and database readiness, performing backups, and creating a migration plan.

    • Migrate data and applications to SAP HANA using tools like SAP DMO or SWPM.

    • Perform post-migration activities such as testing, validation, and optim...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Pricing, delivery and shipment
  • Q2. GST, MTO & MTS process
Round 2 - Technical 

(2 Questions)

  • Q1. STO Process, Export Sales Process
  • Q2. Credit Management
Round 1 - Coding Test 
Round 2 - Technical 

(1 Question)

  • Q1. Oops concepts explain
  • Ans. 

    Oops concepts are fundamental principles of object-oriented programming.

    • Encapsulation - bundling of data and methods that operate on that data

    • Inheritance - ability of a class to inherit properties and methods from a parent class

    • Polymorphism - ability of objects to take on many forms

    • Abstraction - hiding of complex implementation details from the user

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn oops concepts by heart and understand them clearly if possible try their practice example also
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 - Coding Test 

Pattern problem of diamond and find the repeating chharater in string

Round 3 - Aptitude Test 

Maths easy
Basic question of trigonometry and also reasoning and also flowchart algorithm

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy and can be cleared by any confident students just tell them what you know generally they hire all
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Nov 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic .net questions
  • Q2. Few aptitude questions related to straight line

I applied via Naukri.com and was interviewed in Aug 2022. There were 3 interview rounds.

Round 1 - Coding Test 

3 questions test
1st question was coding/programming.
2nd question was on flow chart.
3rd question was mathematical question based on trigonometry.

Round 2 - Coding Test 

Only one question based on data structures and algorithms like find out the 2nd maximum in a array of elements.

Round 3 - One-on-one 

(1 Question)

  • Q1. Director round consisiting of basic questions like travel and home address, holding any other offers.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was quite normal just simple basic questions. Anybody with good knowledge can crack it.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(4 Questions)

  • Q1. Angles between hour hand and minutes hand or second hand
  • Ans. 

    The angle between the hour hand and minute hand of a clock changes continuously as time passes.

    • The angle between the hour hand and minute hand of a clock can be calculated using the formula: |(30*H - (11/2)*M)|, where H is the hour and M is the minute.

    • The angle between the hour hand and second hand of a clock can be calculated using the formula: |(30*H - (59/2)*S)|, where H is the hour and S is the second.

    • The angle bet...

  • Answered by AI
  • Q2. Print diamond structure with stars
  • Ans. 

    Print diamond structure with stars

    • Start with a loop to print spaces before stars

    • Then print stars in a loop

    • Adjust the number of spaces and stars based on the row number to form a diamond shape

  • Answered by AI
  • Q3. Basic Binay search and complexity
  • Q4. This are enough to get into VEST . Same questions are asked to everyone

Interview Preparation Tips

Interview preparation tips for other job seekers - Just do the above questions and u will get selected for sure.. because when I joined all the developers told that this are the same questions asked to us as well ..so prepare the above questions

Interview Questionnaire 

1 Question

  • Q1. What is composite key
  • Ans. 

    A composite key is a combination of two or more columns that uniquely identifies a record in a database table.

    • Composite keys are used to enforce uniqueness in a table.

    • They are created by combining two or more columns that individually may not be unique.

    • Composite keys can be made up of any data type, including strings, numbers, and dates.

    • Example: A table of orders may use a composite key of customer ID and order ID to e...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Reasoning arthemethic 1 hour

Round 2 - Coding Test 

60 mins python need of arrays and ai

AppSys Global Interview FAQs

How many rounds are there in AppSys Global Oracle Technical Consultant interview?
AppSys Global interview process usually has 1 rounds. The most common rounds in the AppSys Global interview process are Technical.

Tell us how to improve this page.

AppSys Global Oracle Technical Consultant Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

CGS Interview Questions
3.6
 • 25 Interviews
Fidel Softech Interview Questions
2.9
 • 8 Interviews
Zentree Labs Interview Questions
3.2
 • 8 Interviews
VisiLean Interview Questions
2.7
 • 5 Interviews
3Di Systems Interview Questions
3.7
 • 5 Interviews
View all
AppSys Global Oracle Technical Consultant Salary
based on 4 salaries
₹1.8 L/yr - ₹5.2 L/yr
43% less than the average Oracle Technical Consultant Salary in India
View more details

AppSys Global Oracle Technical Consultant Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

3.0

Work-life balance

4.0

Salary

3.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Oracle Technical Consultant
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Oracle Apps DBA
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Manager
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Oracle Financial Functional Consultant
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare AppSys Global with

Primus Global Technologies

3.9
Compare

CGS

3.6
Compare

Commerce Pundit

3.8
Compare

Fidel Softech

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