AT&T Senior Software Specialist Interview Questions and Answers

Q1. How to optimise fetching 1 lakh entries from db
Ans. 
Use pagination, indexing, caching, and query optimization to fetch 1 lakh entries efficiently from the database.
• Implement pagination to fetch data in smaller chunks

• Create indexes on columns frequently used in queries

• Use caching to store frequently accessed data

• Optimize queries by avoiding unnecessary joins and using appropriate indexes

• Consider using database-specific optimizations like query hints or stored procedures
Answered by AI
Add your answer

Q1. Reverse a linked list.
Add your answer
Q2. Merge sort on a array/
Add your answer

Q1. Find nth elements from last in linked list
Ans. 
Use two pointers to find the nth element from the end of a linked list.
• Use two pointers, one moving n steps ahead of the other

• When the first pointer reaches the end, the second pointer will be at the nth element from the end
Answered by AI
Add your answer
Q2. Difference between hashmap and concurrent hashmap
Ans. 
HashMap is not thread-safe while ConcurrentHashMap is thread-safe and allows concurrent access.
• HashMap is not thread-safe and can lead to ConcurrentModificationException if accessed by multiple threads simultaneously.

• ConcurrentHashMap allows concurrent access by multiple threads without the need for external synchronization.

• ConcurrentHashMap achieves thread-safety by dividing the map into segments, allowing multiple th...read more
Answered by AI
Add your answer

Q1. What are the things that u do when your what app screen is blank
Ans. 
I would check for internet connection, restart the app, clear cache, and update the app.
• Check internet connection

• Restart the app

• Clear cache

• Update the app
Answered by AI
Add your answer
Q2. Simple python code
Add your answer

Coding test was a DSA question. Moderate difficulty

Q1. Java related questions
Add your answer
Q2. Spring related questions
Add your answer
Q3. Questions related to cloud
Add your answer

Q1. What challenges have I faced in past
Ans. 
I have faced challenges in managing tight project deadlines and adapting to new technologies.
• Managing tight project deadlines by prioritizing tasks and delegating responsibilities

• Adapting to new technologies by self-learning and seeking help from colleagues

• Handling conflicts within team members by effective communication and conflict resolution skills
Answered by AI
Add your answer
Q2. Design level questions
Add your answer
Q3. Microservices design questions
Add your answer

Q1. Teamwork related questions
Add your answer
Q2. SWOT analysis questions
Add your answer
Q3. Salary discussion and expectation
Add your answer

They will give 3 questions

Q1. There will be technical round after finishing of exam
Add your answer
Q2. And HR round also will be same time of Technical
Add your answer

Q1. Questions on ReactJS and code snippets
Add your answer

It was a machine coding round

Q1. Details of what we did on college , project and few programs .
Add your answer