Connectwise India Application Support Engineer Interview Questions and Answers

Q1. What are the issues you are facing daily?
Add your answer

4 coding question easy level questions based on arrays and strings

Code pairing round need to use oops to solve the problem

Q1. Two sum problem
Add your answer
Q2. Internal working of hashmap
Ans. 
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
• HashMap uses hashing to store and retrieve key-value pairs

• It uses an array of linked lists to handle collisions

• The key's hash code is used to determine the index in the array where the key-value pair is stored

• HashMap allows one null key and multiple null values

• Example: HashMap<String, Integer> map = new
Answered by AI
Add your answer
Q3. Sql queries on aggregate function
Add your answer

Q1. Gender equality
Add your answer
Q2. Situation based question
Add your answer

Q1. Out of two table employee and salary join both and 3rd max salary from salary.
Add your answer
Q2. How is problem management done.
Ans. 
Problem management involves identifying, analyzing, and resolving recurring issues to prevent future incidents.
• Identify the root cause of the problem

• Document the problem and its resolution

• Implement corrective actions to prevent recurrence

• Monitor and track the effectiveness of the solution

• Collaborate with stakeholders to ensure continuous improvement
Answered by AI
Add your answer

The questions are medium level more questions on quantitive apptitude

Three questions based on array , string,and time complexity

The whole interview about DSA, oops database and your relevant text

There is two interview around L1 and L2 L1 is about data structure and algorithm and oops. Concept in L2 interview is about all tach stack and resume Q&A, Ask about react, redux, Python DSA, oops, SQL

Q1. Select from employees tables all those who don't work in any department.
Add your answer
Q2. What is a cursor and write a query
Ans. 
A cursor is a database object used to retrieve data from a result set one row at a time.
• A cursor is used to iterate through a result set.

• It can be used to update or delete rows in a table.

• Example query: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

• Example usage: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO @variable1, @variable2;

• Example usage: CLOSE cursor_name; DEALLOCATE cursor_name;
Answered by AI
Add your answer
Q3. How early you can join
Add your answer