Artech Infosystems Application Support Engineer Interview Questions and Answers

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

Oops concepts were judged along with problem solving

Q1. Explain your project
Add your answer
Q2. Design book my show on a high level
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

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

Q1. The duration of the test is around 2 hours. It has questions from DSA on topics like Graphs, Arrays, etc. and MCQs from other topics of OOPS and DBMS. Swapping adjacent, counting votes and Pair Sum.
Add your answer

Q1. Problem statement: Aapali Taxi is a taxi cab operator. They have 3 types of cars- Mini, Sedan and SUV, each with different tariffs. When customers approach them for booking rides, they show an “Estimated ...read more
Add your answer

Q1. 1. Permutations of the string.
Ans. 
Permutations of a string can be generated using recursion and swapping characters.
• Use recursion to generate all possible permutations

• Swap characters to create new permutations

• Store permutations in an array of strings

• Handle duplicate characters to avoid repetition
Answered by AI
Add your answer
Q2. 2. How will you design a database to manage the songs playlist on Spotify?
Ans. 
A database for managing songs on Spotify playlists.
• Create a table for playlists with columns for name, description, and user ID

• Create a table for songs with columns for title, artist, album, and duration

• Create a table for playlist-songs with columns for playlist ID and song ID

• Use foreign keys to link tables together

• Allow for CRUD operations on playlists and songs
Answered by AI
Add your answer
Q3. 3. Middle element of linked list in a single traversal
Ans. 
To find the middle element of a linked list in a single traversal.
• Use two pointers, one moving at twice the speed of the other.

• When the faster pointer reaches the end, the slower pointer will be at the middle.

• If the linked list has even number of elements, the middle will be the second of the two middle elements.
Answered by AI
Add your answer
Q4. 4. Design a list to show songs in the year in which they were published.
Ans. 
Create an array of song titles sorted by year of publication.
• Create an array of song objects with properties for title and year of publication.

• Sort the array by year of publication.

• Extract the titles of the songs into a separate array.

• Return the array of song titles.
Answered by AI
Add your answer
Q5. 5. Another question related to library management class where you have to make diagrams too.
Add your answer

Q1. This Round is comparatively simple and easier than previous rounds. They ask you to introduce yourself followed by questions regarding your background goals, strengths, etc. And discussing some social prob...read more
Add your answer

Q1. OOP based questions - Inheritance, Polymorphism etc
Add your answer
Q2. Project based in depth question - which technology, why
Add your answer
Q3. Data structures concept, programming concepts (i was asked loop vs recurssion)
Add your answer