Upload Button Icon Add office photos
Engaged Employer

i

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

Bajaj Allianz Life Insurance Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer Interview Questions and Answers for Experienced

Updated 13 Jan 2023

Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer 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 in Dec 2022. There were 2 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 we join the tabels and types of join
  • Ans. 

    Joining tables is done using JOIN keyword. Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • JOIN keyword is used to combine rows from two or more tables based on a related column between them.

    • INNER JOIN returns only the matching rows from both tables.

    • LEFT JOIN returns all rows from the left table and the matching rows from the right table.

    • RIGHT JOIN returns all rows from the right table and the m...

  • Answered by AI
  • Q2. What is primary key?
  • Ans. 

    Primary key is a column or set of columns that uniquely identifies each row in a table.

    • Primary key ensures data integrity by preventing duplicate rows.

    • Primary key can be a single column or a combination of columns.

    • Primary key is used as a reference in foreign keys of other tables.

    • Primary key values cannot be null.

    • Primary key values must be unique.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and believe on yourself,
Always listen the question very carefully and take your time and then give the answer

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Sep 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Mostly based on resume. Your experience, what you have done, what all you know. That's all.

Interview Preparation Tips

Interview preparation tips for other job seekers - Not for technical people. If you want managerial role then only apply here.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Nov 2023. There were 2 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 - One-on-one 

(3 Questions)

  • Q1. I am freshers soo please one chance for your company
  • Q2. Yes I am fresher soo for your company work
  • Q3. Talk about a range of elements, including customer service.
  • Ans. 

    Customer service is an essential element in software development.

    • Customer service involves providing support and assistance to users of software applications.

    • It includes addressing user queries, resolving issues, and ensuring customer satisfaction.

    • Software developers may interact with customers through various channels like email, phone, or live chat.

    • Good customer service can lead to positive user experiences and incre...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - job roles that align with your interests and skills. Networking is also a great way to learn about potential career opportunities.
Interview experience
4
Good
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 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 - Technical 

(1 Question)

  • Q1. Coding ques mid level and project
Round 3 - Technical 

(1 Question)

  • Q1. Project discussion
Round 4 - HR 

(1 Question)

  • Q1. Hr ques mixed with project
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Profit loss , number system, code decode

Round 2 - Technical 

(1 Question)

  • Q1. What is DDL, DML, DQL
  • Ans. 

    DDL stands for Data Definition Language, DML stands for Data Manipulation Language, and DQL stands for Data Query Language.

    • DDL is used to define the structure of database objects such as tables, indexes, and views.

    • DML is used to manipulate data in the database, such as inserting, updating, and deleting records.

    • DQL is used to retrieve data from the database using queries.

    • Examples: CREATE TABLE is a DDL statement, INSERT...

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

All aptitude type questions as well as core computer science subject questions comes

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Json data based assignment angular

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic technical question based on js angular

Interview Preparation Tips

Interview preparation tips for other job seekers - fine
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is pointer
  • Ans. 

    A pointer is a variable that stores the memory address of another variable.

    • Pointers are used to access and manipulate memory directly.

    • They are commonly used in programming languages like C and C++.

    • Example: int *ptr; // declares a pointer to an integer variable

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Mar 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference b/w map and array in CPP. What are generators in Python. What is Polynomial Regression? Normalisation in DBMS.
  • Ans. 

    Map and array in CPP are both data structures, but map is a key-value pair container while array is a collection of elements with a fixed size.

    • Map in CPP is a container that stores elements in key-value pairs, allowing fast lookups based on keys.

    • Array in CPP is a collection of elements of the same data type, stored in contiguous memory locations.

    • Generators in Python are functions that allow you to iterate over a sequen...

  • Answered by AI
  • Q2. Realtional Algebra in DBMS
  • Ans. 

    Relational Algebra is a procedural query language used to query databases in DBMS.

    • Relational Algebra is used to perform basic operations like selection, projection, join, etc. on relations.

    • It helps in retrieving specific information from databases based on certain conditions.

    • Examples of operations in Relational Algebra include Union, Intersection, Difference, Cartesian Product, etc.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Expect that all the questions will be from the resume.

Skills evaluated in this interview

I applied via Job Portal

Interview Questionnaire 

1 Question

  • Q1. Java ,.net

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of java .net

Bajaj Allianz Life Insurance Interview FAQs

How many rounds are there in Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer interview for experienced candidates?
Bajaj Allianz Life Insurance interview process for experienced candidates usually has 2 rounds. The most common rounds in the Bajaj Allianz Life Insurance interview process for experienced candidates are Resume Shortlist and Technical.
What are the top questions asked in Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer interview for experienced candidates?

Some of the top questions asked at the Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer interview for experienced candidates -

  1. How we join the tabels and types of j...read more
  2. What is primary k...read more

Tell us how to improve this page.

Bajaj Allianz Life Insurance Oracle SQL and PLSQL Developer Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more
Relationship Manager
765 salaries
unlock blur

₹1.5 L/yr - ₹5 L/yr

Senior Relationship Manager
710 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Business Sales Manager
655 salaries
unlock blur

₹2.7 L/yr - ₹5.8 L/yr

Executive Relationship Manager
621 salaries
unlock blur

₹2.5 L/yr - ₹4.2 L/yr

Senior Business Sales Manager
421 salaries
unlock blur

₹3.1 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Bajaj Allianz Life Insurance with

HDFC Life

3.9
Compare

ICICI Prudential Life Insurance

4.1
Compare

Axis Max Life Insurance

4.1
Compare

ICICI Lombard General Insurance Company

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