BT Group Software Developer 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. 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

Based on python and also question included networking

Test had 2 sections..first section had 3 subsections with quants,verbal and logicals.2nd section is an English writing skill round where they give u a topic and u have to write ur views on it more than 200 words

Gd has the basic rules..they give a topic and u have to discuss on that

Q1. Hr asks you questions on your project,the programming language ur strong in and may be few code solving questions
Add your answer

Q1. HR round tests your flexibility and adaptability skills.
Add your answer

Q1. Tell me about you teaching assistant experience in your university
Add your answer
Q2. Teaching basic programming courses
Add your answer