Onward Technologies Inc Applications Engineer Interview Questions and Answers

Q1. Basic interview question
Add your answer

Q1. Basic interview questions
Add your answer

Q1. Basic info of application development and upload process
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. Had Technical Interview
Add your answer

Q1. Discussion with manager
Add your answer

Q1. Had HR discussion one to one
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. 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