OSI Digital Appian Developer Interview Questions and Answers

MCQ questions related to data structures and algorithms and some easy-medium leetcode coding questions

Q1. A problem was given which was required to be solved using the concepts of OOPS with clean code.
Add your answer

Q1. Introduce yourself and explain any one of the projects
Add your answer
Q2. Questions related to HTML and CSS
Add your answer
Q3. DSA questions related to Strings, two-pointers, maps, etc. Difficulty : easy-medium
Add your answer

Q1. The interviewer asked me to choose a social topic and then questions following to that topic were asked. This round was more of a discussion type round where they checked my social and leadership skills.
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. Appian Design Guidance
Add your answer
Q2. Functions and scenarios
Add your answer

Q1. Manager rounds and Agile methodology
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

Q1. What are your salary expectations?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Tell me about yourself.
Add your answer
Q4. Why did you choose Thoughtworks?
Add your answer

Q1. Code Pairing Round on a github repo
Add your answer
Q2. Add a new feature using SOLID principles and explain your thought process
Ans. 
Adding a new feature using SOLID principles
• Identify the new feature and its requirements

• Analyze the existing codebase and identify areas that need modification

• Apply SOLID principles to design the new feature

• Implement the feature using clean code practices

• Test the feature thoroughly to ensure it meets the requirements
Answered by AI
Add your answer
Q3. Explain the HTTP status code for your tests
Ans. 
HTTP status codes indicate the status of a web request.
• 1xx - Informational

• 2xx - Success

• 3xx - Redirection

• 4xx - Client Error

• 5xx - Server Error

• Examples: 200 OK, 404 Not Found, 500 Internal Server Error
Answered by AI
Add your answer

Q1. Explain your previous project
Add your answer
Q2. What could you have done differently
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Tell me about yourself.
Add your answer
Q4. Social change questions
Add your answer