Upload Button Icon Add office photos

Filter interviews by

Hyundai AutoEver Plsql Developer Interview Questions and Answers

Updated 5 Oct 2024

Hyundai AutoEver Plsql Developer Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Index in PL SQL
  • Ans. 

    Indexes in PL/SQL are database objects that improve the performance of queries by allowing faster data retrieval.

    • Indexes are created on columns in database tables to speed up data retrieval operations.

    • They work by creating a separate data structure that allows the database to quickly locate rows based on the indexed columns.

    • Indexes can be unique or non-unique, and can be created using different methods like B-tree, bit

  • Answered by AI
  • Q2. Mutating Table Error in PLSQL
  • Ans. 

    Mutating table error occurs when a trigger tries to update the same table it is triggered by.

    • Occurs when a trigger attempts to modify the table that is currently being modified by the same trigger

    • Can be avoided by using compound triggers or autonomous transactions

    • Example: Trigger A updates Table X, which causes Trigger A to fire again, resulting in a mutating table error

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Firstly in this mordern timings they will call you at gurgaon for the face to face round.

1. Firstly you have to pay 50 rs per hour parking charges.
2. Then a person named as Guru will make entry like a hero and will give you a booklet to fill.
3. After waiting for hours you will get interview there were two persons out of them one will be continuing playing games on mobile.
4. Even after answering all the questions perfectly and ending the interview with a smiles they will tell you to wait.
5. Then again hero will come back after half an hour and will say feedback is not positive and you can leave.
6. If you will ask for the detailed feedback then he will say abhi to verbally bataya hai baad me bata dunga.

And Trust me this was happening with most of the folks and there are no services like which consultants will tell you like it's a product based etc environment is like hell

And yes consultant name was Vega Intellisoft(Kavipriya), they will keep calling you for multiple times untill you reached there and after that boom vanished

Interview questions from similar companies

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

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

Round 1 - Technical 

(4 Questions)

  • Q1. RANK, WITH CLAUSE, PARTITION, DISTINCT, REF CURSOR
  • Q2. Procedure with Ref cursor AVG, EXISTS, write a block to find factorial
  • Ans. 

    Using PL/SQL to create a procedure with a ref cursor to find the average and factorial of a given number.

    • Create a procedure that takes in a number as input and returns the average of that number using a ref cursor.

    • Use the EXISTS function to check if a factorial exists for a given number.

    • Write a block of code to calculate the factorial of a number using a loop.

  • Answered by AI
  • Q3. Handle duplicate records with case statement
  • Ans. 

    Use a case statement to handle duplicate records in PL/SQL.

    • Use a case statement to check for duplicate records based on specific criteria.

    • Implement logic within the case statement to handle the duplicates appropriately.

    • Consider using a unique identifier or combination of columns to identify duplicates.

  • Answered by AI
  • Q4. Joins, DBMS_PROFILER

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Basic SQL questions
  • Q2. Advanced PLSQL questions
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(1 Question)

  • Q1. What is your approach to building basic logic skills?
  • Ans. 

    My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.

    • Practice problem-solving exercises regularly to strengthen logical thinking abilities.

    • Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.

    • Seek feedback from peers or mentors to identify...

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Some behavioural questions?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Print the following : A BC DEF GHIJ
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Technical MCQ questions on core computer science subjects were asked.

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to find whether the given linked list has loop in it?
  • Q2. Explain osi model with example of browser.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Javascript question
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Core java, advanced java, spring boot, Hibernate, database
  • Q2. Design pattern, previous project experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything whatever mentioned
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - Coding Test 

The interview will last for 30 minutes and will include basic Node.js questions, followed by two coding questions.

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Chitkara Institute of Engineering & Technology, Rajpura and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

3 coding questions, very basic

Round 2 - One-on-one 

(1 Question)

  • Q1. Again DSA and DBMS questions, easy to medium easy

Interview Preparation Tips

Interview preparation tips for other job seekers - Just practice on oops, DSA and DBMS.

Hyundai AutoEver Interview FAQs

How many rounds are there in Hyundai AutoEver Plsql Developer interview?
Hyundai AutoEver interview process usually has 1 rounds. The most common rounds in the Hyundai AutoEver interview process are One-on-one Round.
How to prepare for Hyundai AutoEver Plsql Developer interview?
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 Hyundai AutoEver. The most common topics and skills that interviewers at Hyundai AutoEver expect are PLSQL, Informatica, Performance Tuning, SQL Tuning and Shell Scripting.
What are the top questions asked in Hyundai AutoEver Plsql Developer interview?

Some of the top questions asked at the Hyundai AutoEver Plsql Developer interview -

  1. Mutating Table Error in PL...read more
  2. Index in PL ...read more

Tell us how to improve this page.

Hyundai AutoEver Plsql Developer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Consultant
51 salaries
unlock blur

₹6.5 L/yr - ₹19.5 L/yr

Senior Consultant
26 salaries
unlock blur

₹13 L/yr - ₹26 L/yr

Assistant Manager
25 salaries
unlock blur

₹8 L/yr - ₹17.3 L/yr

Associate Consultant
17 salaries
unlock blur

₹4.6 L/yr - ₹8 L/yr

Senior Executive
9 salaries
unlock blur

₹7 L/yr - ₹9 L/yr

Explore more salaries
Compare Hyundai AutoEver with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Tech Mahindra

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