Upload Button Icon Add office photos
Engaged Employer

i

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

Suma Soft Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Suma Soft Application Support Engineer Interview Questions, Process, and Tips

Updated 8 Aug 2023

Top Suma Soft Application Support Engineer Interview Questions and Answers

Suma Soft Application Support Engineer Interview Experiences

2 interviews found

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

(3 Questions)

  • Q1. What is join? Expain in detail
  • Ans. 

    Join is a SQL operation used to combine rows from two or more tables based on a related column between them.

    • Join is used to retrieve data from multiple tables based on a related column.

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q2. What is stored procedure
  • Ans. 

    Stored procedure is a set of SQL statements that are stored in the database and can be called by name to perform a specific task.

    • Stored procedures can improve performance by reducing network traffic and improving security.

    • They can be used to encapsulate business logic and provide a consistent interface to the database.

    • Stored procedures can accept parameters and return results like a function.

    • Examples: sp_GetCustomerByI

  • Answered by AI
  • Q3. What is like operator
  • Ans. 

    The like operator is used in SQL to search for a specified pattern in a column.

    • The like operator is used with the WHERE clause in a SQL statement

    • It allows for pattern matching using wildcard characters such as % (matches any sequence of characters) and _ (matches any single character)

    • Example: SELECT * FROM table_name WHERE column_name LIKE 'pattern%'

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Always prepare all concept
In sql and plsql property

Skills evaluated in this interview

Round 1 - Technical 

(2 Questions)

  • Q1. What is sql & explain in detald
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases.

    • SQL stands for Structured Query Language

    • It is used to create, modify, and query databases

    • SQL is used in various applications like banking, healthcare, e-commerce, etc.

    • Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE

    • SQL is used to retrieve data from a database based on specific criteria

  • Answered by AI
  • Q2. What is stored procedure
  • Ans. 

    Stored procedure is a precompiled SQL code that can be executed multiple times.

    • Stored procedure is used to improve performance by reducing network traffic and improving security.

    • It can be used to encapsulate business logic and can be called from different applications.

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

    • Example: EXECUTE dbo.uspGetEmployeeManagers @EmployeeID = 50

    • Example: CREATE PR...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Which course you are Certification
  • Ans. 

    I am certified in ITIL Foundation and AWS Solutions Architect Associate.

    • Certified in ITIL Foundation which focuses on IT service management best practices.

    • Certified in AWS Solutions Architect Associate which covers designing and deploying scalable, highly available, and fault-tolerant systems on AWS.

    • Continuously learning and updating my skills through online courses and workshops.

  • Answered by AI
  • Q2. What is your salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - To learn all basic concept about sql & pl sql
Stored procedure, trigger ,function, package, cursor

Skills evaluated in this interview

Application Support Engineer Interview Questions Asked at Other Companies

Q1. what do you know about SQL , Unix , explain in brief
Q2. Add one more column in that table, without using create?
asked in CGI Group
Q3. How do you check how much space is left in the current drive?
asked in CGI Group
Q4. How do you find all the processes that have opened a file in Linu ... read more
asked in Softenger
Q5. How do you find the heap dump files in Linux? What is the role of ... read more

Interview questions from similar companies

I appeared for an interview before Nov 2020.

Interview Questionnaire 

3 Questions

  • Q1. Simple and Easy questions on OOPS, static variable, Prioriry queue,
  • Q2. Design question,
  • Q3. Binary Search

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy you can crack this shit easily

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain

    • Handle edge cases like no fresh oranges or all oranges already rotten

    • Consider using a queue to efficiently process adjacent oranges

  • Answered by AI
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Ans. 

    Find the majority element in an array, return -1 if no majority element exists.

    • Iterate through the array and keep track of the count of each element using a hashmap.

    • Check if any element's count is greater than floor(N/2) to determine the majority element.

    • Return the majority element or -1 if no majority element exists.

  • Answered by AI
  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Ans. 

    Find the Lowest Common Ancestor (LCA) of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the LCA.

    • Handle cases where one node is an ancestor of the other or when one node is the LCA itself.

  • Answered by AI
  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

  • Ans. 

    Reverse words in a string while handling leading/trailing spaces and multiple spaces between words.

    • Split the input string by spaces to get individual words

    • Reverse the list of words

    • Join the reversed words with a single space in between

    • Handle leading/trailing spaces by stripping them before and after reversing

  • Answered by AI
Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Ans. 

    Assign subjects to friends to minimize maximum workload, find minimum time for most loaded friend.

    • Sort subjects in descending order

    • Assign subjects to friends one by one until all subjects are assigned

    • The maximum workload will be the sum of problems assigned to the friend with the most problems

    • Return the maximum workload as the minimum time required

  • Answered by AI
  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Ans. 

    Find the total sum of all root to leaf paths in a binary tree formed by concatenating node values.

    • Traverse the binary tree from root to leaf nodes, keeping track of the current path sum

    • Add the current path sum to the total sum when reaching a leaf node

    • Use modulo (10^9 + 7) to handle large outputs

  • Answered by AI
  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I appeared for an interview in Sep 2019.

Interview Questionnaire 

1 Question

  • Q1. Pl sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - y resume was referd through a guy. Later I got call from HR for interview schedule he asked me my expected ctc and Notice Period to which I clearly said 3 months. He scheduled my interview on weekends morning 8am I reached there by 8.30am The interview process got started late by 10am it was an walk in type interview 1 round was Technical I cleared that round and had a feedback session with HR he said we are processing u to next round which was Manager round there itself I told the HR my NP is 3months the Hr Told its not an issue.
Laterly after I had lunch by 2pm Hr came n told me that Manager is not available now so we will be conducting ur further round in weekdays.
Then there was no mail or call so I purposely mailed them still haven't got proper response from them, so at last I told my friend who referd me to ask for an update the same HR told him that they want Immediate joiner so we can't process him to further round. Wasted my whole day over there

I applied via Recruitment Consultant and was interviewed before Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What Prog Languages known? Prior Software Experience? How good on U.S. Client Face to Face and telephonic interaction for projects?
  • Ans. 

    I am proficient in Java, Python, and C++. I have 2 years of experience in software development. I have excellent communication skills for client interaction.

    • Proficient in Java, Python, and C++

    • 2 years of software development experience

    • Excellent communication skills for client interaction

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I wasn't fluent or good in Programming languages but I was clear on the flowchart and the basic concept of OOPS. Also, I was confident about solving the scenarios given to me at interview rounds. I also had good experience in US customer handling over telephonic and Face to Face interaction.

I applied via Walk-in and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

Data structures and algorithms

Round 2 - Coding Test 

Python etl,pandas, pyspark questions

Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation , work culture

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with the basics and practice common programming problems

Interview Questionnaire 

2 Questions

  • Q1. Basics from all framework you have worked on.
  • Q2. There working all are non technical people's they don't know the projects here major people working in testing and non related work

I applied via first naukari and was interviewed before Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. A graph is stored in sql database. Questions was to find the shorted path between point A and B.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was quite simple. Basics of python and database were asked and some problem solving questions.

Suma Soft Interview FAQs

How many rounds are there in Suma Soft Application Support Engineer interview?
Suma Soft interview process usually has 2-3 rounds. The most common rounds in the Suma Soft interview process are Resume Shortlist, Technical and HR.
How to prepare for Suma Soft Application Support Engineer 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 Suma Soft. The most common topics and skills that interviewers at Suma Soft expect are Application Support, MongoDB, MySQL, Night Shift and PHP.
What are the top questions asked in Suma Soft Application Support Engineer interview?

Some of the top questions asked at the Suma Soft Application Support Engineer interview -

  1. What is sql & explain in det...read more
  2. What is join? Expain in det...read more
  3. Which course you are Certificat...read more

Tell us how to improve this page.

Suma Soft Application Support Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 337 Interviews
CitiusTech Interview Questions
3.4
 • 272 Interviews
NeoSOFT Interview Questions
3.6
 • 266 Interviews
Tiger Analytics Interview Questions
3.7
 • 225 Interviews
Episource Interview Questions
3.9
 • 220 Interviews
Altimetrik Interview Questions
3.8
 • 218 Interviews
Incedo Interview Questions
3.1
 • 182 Interviews
Xoriant Interview Questions
4.1
 • 182 Interviews
View all
Suma Soft Application Support Engineer Salary
based on 7 salaries
₹1.8 L/yr - ₹3.5 L/yr
42% less than the average Application Support Engineer Salary in India
View more details

Suma Soft Application Support Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

3.0

Salary

5.0

Job security

5.0

Company culture

3.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Back Office Executive
248 salaries
unlock blur

₹0.9 L/yr - ₹3 L/yr

Software Engineer
148 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Customer Care Executive
93 salaries
unlock blur

₹1 L/yr - ₹3.2 L/yr

Software Developer
88 salaries
unlock blur

₹2 L/yr - ₹8.6 L/yr

Sales Executive
71 salaries
unlock blur

₹1.4 L/yr - ₹3.6 L/yr

Explore more salaries
Compare Suma Soft with

ITC Infotech

3.6
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

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