Advantmed Desktop Support Engineer Interview Questions and Answers for Experienced

Math and verbal round .

General topics to speak

Q1. Duplicates in array College Projects Hashmap implementation
Ans. 
Implement a function to find duplicates in an array of strings using Hashmap.
• Create a Hashmap to store the frequency of each string in the array

• Iterate through the array and check if the frequency of any string is greater than 1

• If yes, add it to the list of duplicates

• Return the list of duplicates
Answered by AI
Add your answer

Q1. Current company project and tech stack related
Add your answer
Q2. Very basic selenium and java interview questions asked verbally
Add your answer
Q3. 30 min interview
Add your answer

Q1. Write code in java for following input String s = "abdc112kg45ldy4p9" to get output sum = 170.
Add your answer
Q2. Some basic selenium, testng, cucumber bdd questions
Add your answer
Q3. Its a 40 min coding round
Add your answer

Q1. Java code in order to find the day if we give jan 1 as monday. then what day is sept 14.
Add your answer
Q2. Selenium Xpath related questions to find it in website of flipkart sellers page.
Add your answer
Q3. Show nullpointer error using java code.
Add your answer
Q4. Selenium, TestNG, Cucumber Questions
Add your answer
Q5. 45 min high level technical round
Add your answer

Q1. General discussion related to current company tecstack and work.
Add your answer
Q2. General Managerial Round/HR Round questions related to cultural or behavioral fit.
Add your answer
Q3. 30 min short discussion
Add your answer

Q1. Discuss the project you are most proud of
Ans. 
Developed a mobile app for tracking personal fitness goals
• Used React Native to create a cross-platform app

• Implemented features such as goal setting, progress tracking, and workout logging

• Integrated with wearable devices like Fitbit for automatic data syncing
Answered by AI
Add your answer
Q2. What are ways to speed up SQL queries? List them in increasing order of complexity?
Ans. 
Ways to speed up SQL queries in increasing order of complexity
• Use indexes on columns frequently used in WHERE clauses

• Optimize queries by avoiding unnecessary joins and subqueries

• Use stored procedures to reduce network traffic and improve performance

• Consider denormalizing tables for frequently accessed data

• Use query optimization techniques like query caching and query hints
Answered by AI
Add your answer
Q3. Is Redis single-threaded or multi-threaded?
Ans. 
Redis is single-threaded.
• Redis is single-threaded, meaning it can only execute one command at a time.

• This design choice allows Redis to be extremely fast and efficient for certain use cases.

• However, it also means that Redis may not be the best choice for highly concurrent workloads.
Answered by AI
Add your answer
Q4. What sort of data types can be used as keys in Python?
Ans. 
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
• Strings are commonly used as keys in Python dictionaries.

• Integers and floats can also be used as keys.

• Tuples can be used as keys if they only contain immutable elements.

• Custom objects can be used as keys if they are hashable.

• Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Answered by AI
Add your answer
Q5. What types of indexing exist in SQL?
Ans. 
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
• Clustered index physically reorders the table based on the index key

• Non-clustered index creates a separate structure for the index

• Unique index ensures that all values in the index column are unique

• Composite index uses multiple columns for indexing
Answered by AI
Add your answer

Q1. Discussion with panel
Add your answer

Q1. Discussion with hr manager
Add your answer