Artech Infosystems Application Support Engineer Interview Questions and Answers

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

IT WAS GOOD MOSTLY FOCUS IS ON BASICS OF PYTHON LINKDEDLIST

Q1. WHY DO WE HIRE YOU?
Add your answer
Q2. How do you rate interview expericnece
Add your answer

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

Q1. Sql basic joins , fliter condition, group order clause , select query for getting complex output from table
Add your answer
Q2. About yourprojrct waht u did etc
Add your answer

Coding plus aptitude

Code pairing round with one question and an hour to solve

Q1. Oops, dsa, java
Add your answer
Q2. Projesct related
Add your answer

Q1. Cultural fit round was kinda HR but more topics involved
Add your answer

Q1. Build an architecture for an ecommerce application
Ans. 
An architecture for an ecommerce application involves multiple components like front-end, back-end, database, and payment gateway.
• Separate front-end and back-end for scalability and maintainability

• Use microservices architecture for flexibility and scalability

• Implement a robust database system for storing product information, user data, and transactions

• Integrate a secure payment gateway for processing payments

• Utilize ca
Answered by AI
Add your answer

2 leetcode medium level type problems were given. This was a cut-off test were majority will be cut-off.

Long coding round - Paired with another thoughtworker

Q1. Questions on project
Add your answer
Q2. Frameworks related
Add your answer