Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Yalamanchili Software Exports Plsql Developer Interview Questions and Answers

Updated 16 Mar 2023

Yalamanchili Software Exports Plsql Developer Interview Experiences

1 interview found

Plsql Developer Interview Questions & Answers

user image Gulshan Jamaiwar

posted on 16 Mar 2023

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

I applied via Walk-in and was interviewed in Feb 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 Resume tips
Round 2 - Aptitude Test 

25 Aptitude MCQ and 25 post based MCQ

Round 3 - Technical 

(1 Question)

  • Q1. They are asking Technical Questions
Round 4 - HR 

(1 Question)

  • Q1. They are asking HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - It is Fintech Domain Company which is mostly working on Cards and Payments

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
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. EXPLAIN ABOUT UR PRJECT
  • Ans. 

    Developed a PL/SQL project for managing inventory and sales data in a retail store.

    • Designed database tables to store product information, sales transactions, and customer details.

    • Implemented PL/SQL procedures and functions for adding, updating, and querying data.

    • Created triggers to enforce business rules and maintain data integrity.

    • Developed reports using PL/SQL queries to analyze sales performance and inventory levels

  • Answered by AI
  • Q2. How do you work on performance optimization
  • Ans. 

    I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.

    • Analyzing query execution plans to identify bottlenecks

    • Creating appropriate indexes to improve query performance

    • Refactoring code to optimize resource usage

    • Using tools like Explain Plan and SQL Tuning Advisor

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2023. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Window Functions in SQL
  • Ans. 

    Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used to calculate values based on a set of rows related to the current row.

    • They allow you to perform calculations without grouping the rows into a single output row.

    • Examples of window functions include ROW_NUMBER(), RANK(), and LAG().

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Uses of Packages in PL/SQL
  • Ans. 

    Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.

    • Packages help in modularizing code for easier maintenance and debugging

    • They provide encapsulation and hide implementation details

    • Packages can contain multiple procedures, functions, variables, cursors, and exceptions

    • They improve performance by reducing network traffic

    • E...

  • Answered by AI

Skills evaluated in this interview

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
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

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

Round 1 - Assignment 

Oracle pl sql developer

Interview Preparation Tips

Interview preparation tips for other job seekers - Np
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Factorial of a number
  • Ans. 

    Factorial of a number is the product of all positive integers up to that number.

    • To calculate factorial of a number, multiply all positive integers up to that number.

    • Factorial of 0 is 1.

    • Example: Factorial of 5 is 5*4*3*2*1 = 120.

  • Answered by AI
  • Q2. Sql queries including 2nd highest salary and table joins
Round 2 - Technical 

(2 Questions)

  • Q1. Sql question and table joins
  • Q2. Modelling of schema
  • Ans. 

    Modelling of schema involves designing the structure of a database to organize and represent data.

    • Identify entities and their relationships

    • Define attributes for each entity

    • Establish primary and foreign keys

    • Normalize the schema to reduce redundancy

    • Consider performance and scalability

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Some sql queries
1 DSA prime no

Skills evaluated in this interview

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

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

Round 1 - Technical 

(1 Question)

  • Q1. What is packages and types
  • Ans. 

    Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.

    • Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.

    • Types are user-defined data structures that can be used to define new data types in PL/SQL.

    • Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...

  • Answered by AI

Skills evaluated in this interview

I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 1. Tell me about yourself. 2. Topics like Stored procedure, functions, cursors, package.

Interview Preparation Tips

Topics to prepare for TCS Plsql Developer interview:
  • PLSQL
  • SQL
  • Stored Procedures
  • Sql function
Interview preparation tips for other job seekers - Prepare those topics.
I got shortlisted after the interview but due to some technical issu in their portal, I couldn't upload my documents. I mailed them multiple times but got no help, no calls from any person and some of my friends also told me they faced many situations and none from TCS helped them out.
So, my advice will be don't for that company. Prepare for others.
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

Contribute & help others!
anonymous
You can choose to be anonymous

Yalamanchili Software Exports Interview FAQs

How many rounds are there in Yalamanchili Software Exports Plsql Developer interview?
Yalamanchili Software Exports interview process usually has 4 rounds. The most common rounds in the Yalamanchili Software Exports interview process are Resume Shortlist, Aptitude Test and Technical.
How to prepare for Yalamanchili Software Exports 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 Yalamanchili Software Exports. The most common topics and skills that interviewers at Yalamanchili Software Exports expect are Analytical skills, Data Modeling, Data migration, Database and Oracle Database.

Recently Viewed

SALARIES

Ashirvad Pipes

INTERVIEWS

Shell Recharge Solutions

No Interviews

INTERVIEWS

Arista Networks

No Interviews

INTERVIEWS

Yalamanchili Software Exports

No Interviews

SALARIES

Arista Networks

LIST OF COMPANIES

Yalamanchili Software Exports

Locations

INTERVIEWS

Shell Recharge Solutions

No Interviews

INTERVIEWS

Arista Networks

No Interviews

SALARIES

Ashirvad Pipes

SALARIES

Aliaxis Utilities And Industry

Tell us how to improve this page.

Yalamanchili Software Exports Plsql Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Yalamanchili Software Exports Plsql Developer Salary
based on 16 salaries
₹1.6 L/yr - ₹3.8 L/yr
56% less than the average Plsql Developer Salary in India
View more details

Yalamanchili Software Exports Plsql Developer Reviews and Ratings

based on 3 reviews

3.9/5

Rating in categories

4.1

Skill development

3.9

Work-life balance

2.7

Salary

5.0

Job security

3.6

Company culture

3.3

Promotions

3.9

Work satisfaction

Explore 3 Reviews and Ratings
Software Developer
135 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Executive
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive Software Developer
39 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Application Support Engineer
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Client Account Manager
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Yalamanchili Software Exports with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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