AVASOFT Software Developer Interview Questions and Answers for Freshers

Coding questions related to trees and graphs

Q1. Anagrams related
Add your answer
Q2. Sorting related
Add your answer

Aptitude test was very easy

Q1. What is OOP’s Concept and how using in DotNet
Ans. 
OOP stands for Object-Oriented Programming, a programming paradigm based on the concept of objects.
• OOP focuses on creating objects that contain data and methods to manipulate that data.

• In DotNet, OOP is implemented using classes and objects. Classes define the blueprint for objects, while objects are instances of classes.

• Encapsulation, inheritance, and polymorphism are key principles of OOP that are utilized in DotNet ...read more
Answered by AI
Add your answer
Q2. What is Mvc and what is the role in DotNet
Ans. 
MVC stands for Model-View-Controller. It is a design pattern used in DotNet for separating concerns in an application.
• Model represents the data and business logic of the application.

• View is responsible for displaying the user interface.

• Controller handles user input and updates the model and view accordingly.

• MVC helps in achieving separation of concerns, making the code more organized and maintainable.

• Example: In a DotN...read more
Answered by AI
Add your answer
Q3. What are the types of joins in Ms Sql
Ans. 
Types of joins in Ms Sql include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is at least one match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer
Q4. What is store procedure in Ms Sql
Ans. 
A stored procedure in MS SQL is a precompiled collection of SQL statements that can be saved and reused.
• Stored procedures can improve performance by reducing the amount of data sent over the network.

• They can be used to encapsulate business logic and provide a layer of security by controlling access to data.

• Stored procedures can accept input parameters and return output parameters or result sets.

• Example: CREATE PROCEDUR...read more
Answered by AI
Add your answer
Q5. What is the significance of Sql joins in database management
Ans. 
Sql joins are used to combine rows from two or more tables based on a related column between them.
• Joins are essential for retrieving data from multiple tables in a database

• Types of joins include inner join, outer join, left join, and right join

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Online Coding test conducted virtually .

Q1. Python fundamentals and java fundamentals
Add your answer

Q1. Asking About us and Background?
Add your answer

Q1. Tell me about yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Motivation behind the move
Ans. 
I was motivated to move to this role because of my passion for coding and desire to work on challenging projects.
• Passion for coding and technology

• Desire to work on challenging projects

• Opportunity for growth and learning

• Interest in the company's products or services
Answered by AI
Add your answer

Q1. They will ask questions based on what you have mentioned in your resume
Add your answer

Q1. They have asked about my previous company project and questions related to that
Add your answer

Round duration - 50 Minutes
Round difficulty - Medium

1 Coding question

Q1. Meeting
Ninja is organizing a meeting in an office that starts at a time ‘0’ and will end at a time ‘LAST’. There are ‘N’ presentations that are going to take place in that meeting whose start and end time...read more
Ans. Brute Force Approach
Algorithm:
 
• The idea here is to find the maximum sum subarray of size ‘K+1’, where the array will contain empty slots.
• First, we create an array named emptySlots[], to store the time duration in which there is no presentation.
• Run a loop to traverse all presentations, and in each iteration, add START[i] - END[i-1] (which gives a free slot between the ith presentation) into the array emptySlots[].
• N...read more
Answered by CodingNinjas
View 1 more amswer

Round duration - 90 Minutes
Round difficulty - Medium

It was an online technical round. There were around 20 MCQs and two coding questions. The round had an login window of 30 minutes. One coding question was of the level leetcode medium and the other was leetcode hard.

Q1. Search in a row wise and column wise sorted matrix
You are given an N * N matrix of integers where each row and each column is sorted in increasing order. You are given a target integer 'X'. Find t...read more
Ans. Brute Force
• Run a loop from i = 0 to N - 1, to check each row.
  • Run a loop from j = 0 to N - 1, to check each element of the row.
    • If there is a match, return {i, j}.
• If the element is not found in the entire matrix, return {-1, -1}
Space Complexity: O(1)Explanation:
O(1).
 
Since only constant extra space is required.
Time Complexity: O(n^2)Explanation:
O(N ^ 2), where ‘N’ is the number of rows or columns in the matrix.
&nb...read more
Answered by CodingNinjas
View 2 more amswers
Q2. Euler’s Totient Function
You are given an integer 'N'. Your task is to count the number of integers between 1 and 'N' both inclusive which are coprime to 'N'.
Note:
Two numbers ar...read more
Ans. Euler’s product formula
The better solution is to use Euler’s product formula which states that the total number of integers between 1 and N - 1 inclusive which are coprime to N can be found using this formula Euler Product Formula N * (1 - (1 / p1)) * (1 - (1 / p2)) *.......* (1 - (1 / pk)) where p1,p2...pk are the prime factors of N.
 
So now the problem is to find all the prime factors and use the above formula.
&n...read more
Answered by CodingNinjas
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

It was a technical + HR round. The interview panel consisted of two technical guys and one person from HR.

Q1. Sort Array Of Strings
You are given an array of strings 'ARRSTR[]' of size 'N' and a character 'C'. Your task is to sort the 'ARRSTR[]' according to the new alphabetical ord...read more
Ans. HashMap Approach
Approach: The idea here is to use a data structure HashMap to store each character’s order in the new alphabetical order, starting with a letter c (given in the problem). Now, start comparing the strings in the ‘ARRSTR[]’ using HashMap that has been created to define the order.
 
Suppose that we are comparing two strings of ‘ARRSTR[]’ named ‘X’ and ‘Y’. Let us assume that we have found the first diff...read more
Answered by CodingNinjas
Add your answer
Q2. DBMS Question
What are ACID Properties?
What is a foriegn key?
Some SQL Queries on JOINS
Add your answer
Q3. OOPS Questions
Explain Pillars of OOPS
Add your answer