Upload Button Icon Add office photos
Engaged Employer

i

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

AVASOFT Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

AVASOFT Plsql Developer Interview Questions and Answers

Updated 7 Oct 2021

AVASOFT Plsql Developer Interview Experiences

1 interview found

Plsql Developer Interview Questions & Answers

user image santhiya muthuvel

posted on 7 Oct 2021

I applied via Recruitment Consultant and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Real time example for normalization
  • Ans. 

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

    • Normalization helps to eliminate data redundancy and inconsistencies

    • It ensures that each piece of data is stored in only one place

    • It reduces the chances of data anomalies and inconsistencies

    • Normalization is achieved through a series of steps called normal forms

    • Examples of normalization include breaking down a c...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in plsql as well as mysql

Interview questions from similar companies

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

I applied via campus placement at Dayananda Sagar College of Engineering, Bangalore and was interviewed in Oct 2024. There were 4 interview rounds.

Round 1 - Coding Test 

3 coding dsa question
Difficulty is On your luck
My friends got easy level
I got medium level
Some got hard questions as well

Round 2 - Aptitude Test 

Ssh round , quant and logical
Tip: bring your calculator

Round 3 - Technical 

(3 Questions)

  • Q1. Two Puzzle : bulb switching and candle
  • Q2. Dsa questions such as string reverse, binary search
  • Q3. Dbms and os core subject questions
Round 4 - HR 

(2 Questions)

  • Q1. How are you better than others
  • Q2. Why should we hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are a girl, the interview rounds will be much easier for you as this company promotes diversity hiring.
The main differing factor is technical round interview which totally depends on the interviewer's mood .
Girls do get priority in this round, they are asked easier questions and will be selected if able to answer 60-70% of the questions.
Note:- it's not like they will hire any girl but a bit easier comparatively
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackerrank 3 questions were given of binary search dp and a math coding question

Round 2 - Technical 

(2 Questions)

  • Q1. Heap hard question
  • Q2. Nothing only one question was asked

Interview Preparation Tips

Interview preparation tips for other job seekers - I was not up to the mark
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. I don't Remember the question1
Round 2 - Technical 

(2 Questions)

  • Q1. I don't remember the question2
  • Q2. I don't remember the question
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. What is use of constructors in Js
  • Ans. 

    Constructors in JavaScript are used to create and initialize objects.

    • Constructors are functions that are used to create new instances of objects.

    • They are called with the 'new' keyword to create a new object based on the constructor's blueprint.

    • They can also be used to set initial values or properties for the object being created.

    • Example: function Person(name, age) { this.name = name; this.age = age; }

    • Example: var perso

  • Answered by AI

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Time based test with basic questions

Round 2 - Coding Test 

Basic level coding round in preferred language

Round 3 - Technical 

(2 Questions)

  • Q1. About projects done in college
  • Q2. Coding round

Interview Preparation Tips

Interview preparation tips for other job seekers - Be well versed with basics
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Shine

Round 1 - Technical 

(2 Questions)

  • Q1. What is closures
  • Ans. 

    Closures are functions that have access to variables from their outer scope even after the outer function has finished executing.

    • Closures allow functions to access variables from their parent function even after the parent function has returned.

    • They help in creating private variables and functions in JavaScript.

    • Closures are commonly used in event handlers and callbacks.

  • Answered by AI
  • Q2. What is call apply bind
  • Ans. 

    call, apply, and bind are methods in JavaScript used to manipulate the context of a function.

    • call() is used to invoke a function with a specified 'this' value and arguments provided individually.

    • apply() is similar to call() but arguments are passed as an array.

    • bind() is used to create a new function with a specified 'this' value and initial arguments.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Globant UI Developer interview:
  • Javascript
  • Angular
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via AmbitionBox and was interviewed in Jul 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 tips
Round 2 - Coding Test 

Uging tag , elements, div, selector, flex box etc

Round 3 - Technical 

(4 Questions)

  • Q1. Html, CSS, JavaScript, bootstrap
  • Q2. Good knowledge for html CS
  • Q3. Bootstrap using responsible website
  • Ans. 

    Bootstrap is a front-end framework that helps in creating responsive websites by using a grid system and predefined classes.

    • Bootstrap provides a grid system with 12 columns that automatically adjusts based on screen size.

    • It includes responsive utility classes like 'd-none' and 'd-md-block' to show/hide content based on screen size.

    • Bootstrap also offers responsive navigation components like the navbar that collapses int

  • Answered by AI
  • Q4. Anything else any more times

Interview Preparation Tips

Interview preparation tips for other job seekers - I have completed dipin Computer science Engineering
I am creative and hard working person

Skills evaluated in this interview

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

I applied via campus placement at Kongu Engineering College, Erode and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Written test coding and with aptitude questions are asked

Round 2 - Technical 

(1 Question)

  • Q1. Asking about OOPS and C++ basics concepts
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 Jul 2023. 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. What is javascript?
  • Ans. 

    JavaScript is a high-level, interpreted programming language that is used to make web pages interactive and dynamic.

    • JavaScript is commonly used for client-side web development.

    • It can be used to create interactive features like forms, animations, and dynamic content.

    • JavaScript can also be used for server-side development with Node.js.

  • Answered by AI
  • Q2. Types of variable in JavaScript
  • Ans. 

    Types of variables in JavaScript include var, let, and const.

    • var: globally scoped or function scoped

    • let: block scoped, can be reassigned

    • const: block scoped, cannot be reassigned

  • Answered by AI

Skills evaluated in this interview

Tell us how to improve this page.

Software Engineer
234 salaries
unlock blur

₹1.8 L/yr - ₹9.9 L/yr

Data Engineer
91 salaries
unlock blur

₹3.4 L/yr - ₹8 L/yr

Software Developer
61 salaries
unlock blur

₹3 L/yr - ₹9.4 L/yr

QA Engineer
54 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Servicenow Developer
52 salaries
unlock blur

₹4 L/yr - ₹7 L/yr

Explore more salaries
Compare AVASOFT 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