Upload Button Icon Add office photos
Engaged Employer

i

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

Harjai Computers Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Harjai Computers Plsql Developer Interview Questions and Answers

Updated 26 Nov 2022

Harjai Computers Plsql Developer Interview Experiences

1 interview found

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. WRITE A PROCEDURE WHICH U WRITTEN LAST?
  • Ans. 

    I wrote a procedure to calculate the average salary of employees in a department.

    • Used cursor to fetch employee data

    • Calculated total salary using loop

    • Divided total salary by number of employees

    • Handled exceptions for zero employees in department

  • Answered by AI
  • Q2. MERGE CONCEPT RELATED

Interview Preparation Tips

Interview preparation tips for other job seekers - DONT GET PANIC THERE ARE MANY COMPANIES ,GIVE UR INTERVIEW FREELY

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. They have only one phone interview
  • Q2. They asking about full sql and plsql

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. CREATE A FUNCTION BASED ONLOGIC SHARED
  • Ans. 

    Create a function based on shared logic

    • Identify common logic that can be reused in multiple functions

    • Create a separate function to encapsulate the shared logic

    • Call the shared function from other functions where the logic is needed

  • Answered by AI
  • Q2. FOR AN ENTITY GIVE DTAILS OF PREVOUS AND NEXT DATE FOR PARTICULAR DEPATMENT
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Types of cursors
  • Ans. 

    Types of cursors include implicit, explicit, and parameterized cursors.

    • Implicit cursors are automatically created by Oracle when a SQL statement is executed.

    • Explicit cursors are defined by the programmer using the DECLARE, OPEN, FETCH, and CLOSE statements.

    • Parameterized cursors allow for dynamic SQL statements to be executed with different parameters.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare plsql topics well.

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Question based on PLSQL
  • Q2. What is Execution Plan, Query Optimization
  • Ans. 

    Execution plan is a roadmap created by the database optimizer to determine the most efficient way to execute a query.

    • Execution plan shows the steps the database will take to execute a query.

    • Query optimization involves finding the most efficient way to execute a query.

    • Optimization techniques include index usage, join methods, and access paths.

    • Understanding execution plans helps in tuning queries for better performance.

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

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

Round 1 - Technical 

(4 Questions)

  • Q1. Sql loader questions - Give command
  • Q2. Difference in procedure and function
  • Ans. 

    Procedure is used to perform an action, while function returns a value.

    • Procedure does not return a value, while function does

    • Functions can be used in SQL queries, procedures cannot

    • Functions can be called from SQL statements, procedures cannot

  • Answered by AI
  • Q3. What is init in performance tuning?
  • Ans. 

    In performance tuning, init refers to the initialization parameter file used by Oracle Database to configure various settings.

    • init is a text-based configuration file that contains parameters to optimize the performance of Oracle Database.

    • It is used to set parameters such as memory allocation, parallel processing, and resource utilization.

    • By tuning the init file, developers can improve the overall performance of the dat...

  • Answered by AI
  • Q4. Exception handling - Named and unnamed. Give exceptions names.
  • Ans. 

    Named and unnamed exceptions in PL/SQL with examples

    • Named exceptions are user-defined exceptions with specific names like 'custom_exception'

    • Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'

    • Named exceptions can be raised using RAISE statement with the exception name

    • Unnamed exceptions are raised automatically by the system in case of errors

    • Example of named exception: DECLARE custom_exce...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know the basics. But Infosys keeps people waiting in queue for months before giving out the results.

Plsql Developer Interview Questions & Answers

Infosys user image Bvm Bharath Kumar

posted on 14 Oct 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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. Dif between SQL n plsql
  • Ans. 

    SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

    • SQL is used for querying and manipulating data in databases.

    • PL/SQL is used for writing procedural code like loops, conditions, and functions.

    • SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

    • PL/SQL can be used to create stored procedures, functions, and triggers i...

  • Answered by AI
  • Q2. Structure query language and extension version of sql
  • Ans. 

    SQL is a structured query language used to communicate with databases. SQL extensions add additional functionality to the language.

    • SQL is a standard language used to interact with databases

    • SQL extensions like PL/SQL add procedural programming capabilities to SQL

    • PL/SQL is an extension of SQL used in Oracle databases

  • Answered by AI

Skills evaluated in this interview

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is a cursor. And its types
  • Ans. 

    A cursor is a database object used to retrieve data from a result set one row at a time.

    • Types of cursors: Implicit, Explicit, Ref, and Dynamic

    • Implicit cursor is used for single row queries

    • Explicit cursor is used for multi-row queries

    • Ref cursor is used to point to a cursor variable

    • Dynamic cursor is used to execute dynamic SQL statements

  • Answered by AI
  • Q2. Functions and procedures
  • Q3. Triggers and its types and syntax
  • Ans. 

    Explanation of triggers and their types in PL/SQL

    • Triggers are database objects that are automatically executed in response to certain events

    • Types of triggers include DML, DDL, and system triggers

    • Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;

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

(1 Question)

  • Q1. What is SQL optimization. Normalization. Pragma usage
  • Ans. 

    SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.

    • SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.

    • Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Pragma is a compiler directive that provides additional information ...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, asked about having any other offer in hand

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up SQL queries and procedures, function, triggers

Skills evaluated in this interview

Round 1 - Technical 

(3 Questions)

  • Q1. SQL queries, joins, views, functions , advanced functions, exceptions.. Lot of Scenario based question
  • Q2. About resume and past experiences
  • Q3. Interview happened almost 1hr
Round 2 - HR 

(1 Question)

  • Q1. After 30 days.. Do u have any other offer in hand? How much they offered

Interview Preparation Tips

Interview preparation tips for other job seekers - After 30 days after n number of follow up mail
Hr discussion happened. Which was surprising one. The package they offfered is very less for an experienced candidate .. It doesn't even have 20%hike from current salary.

I applied via LinkedIn and was interviewed in May 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. Views and triggers basics
  • Q2. Learning capabilities of new softwares
  • Ans. 

    I have a strong ability to learn new software quickly.

    • I am a self-motivated learner and enjoy exploring new technologies.

    • I am comfortable with online tutorials, documentation, and experimenting with new software.

    • I have experience learning new software such as Oracle SQL Developer, Toad, and PL/SQL Developer.

    • I am able to adapt to new software quickly and efficiently.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic sql queries and questions are asked like views, stored procedures and triggers and subqieries and functions

Harjai Computers Interview FAQs

How many rounds are there in Harjai Computers Plsql Developer interview?
Harjai Computers interview process usually has 2 rounds. The most common rounds in the Harjai Computers interview process are Resume Shortlist and Technical.
How to prepare for Harjai Computers 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 Harjai Computers. The most common topics and skills that interviewers at Harjai Computers expect are PLSQL.
What are the top questions asked in Harjai Computers Plsql Developer interview?

Some of the top questions asked at the Harjai Computers Plsql Developer interview -

  1. WRITE A PROCEDURE WHICH U WRITTEN LA...read more
  2. MERGE CONCEPT RELA...read more

Tell us how to improve this page.

Harjai Computers Plsql Developer Salary
based on 14 salaries
₹6 L/yr - ₹10 L/yr
36% more than the average Plsql Developer Salary in India
View more details

Harjai Computers Plsql Developer Reviews and Ratings

based on 2 reviews

2.1/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

4.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 2 Reviews and Ratings
Softwaretest Engineer
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Tester
93 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

HR Executive
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Harjai Computers with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

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