Upload Button Icon Add office photos

Filter interviews by

411 Locals Technical Lead Interview Questions and Answers for Experienced

Updated 18 Jun 2021

411 Locals Technical Lead Interview Experiences for Experienced

1 interview found

I applied via Recruitment Consultant and was interviewed before Jun 2020.Ā There were 4 interview rounds.

Interview QuestionnaireĀ 

3 Questions

  • Q1. How to optimize SQL and database?
  • Ans. 

    Optimizing SQL and database involves improving query performance and database design.

    • Use indexes to speed up query execution

    • Normalize database tables to reduce redundancy

    • Avoid using SELECT * and instead specify required columns

    • Use stored procedures to reduce network traffic

    • Regularly analyze and optimize database performance

  • Answered by AI
  • Q2. Which all control statements are there in the database? Why we need it?
  • Ans. 

    Control statements in database are used to control the flow of execution of SQL statements.

    • Control statements in database include IF, CASE, WHILE, LOOP, and GOTO.

    • They are used to control the flow of execution of SQL statements.

    • They help in making decisions, looping through data, and jumping to specific parts of code.

    • For example, the IF statement can be used to check a condition and execute a block of code if the condit...

  • Answered by AI
  • Q3. Prepare on basics of PHP and few logical code relate

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was completely technical based on your problem-solving ability.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Feb 2021.Ā There were 3 interview rounds.

Interview QuestionnaireĀ 

1 Question

  • Q1. Fiori elements Git BTP

Interview Preparation Tips

Interview preparation tips for other job seekers - Explore on new technology and SAP Tools

I applied via Naukri.com and was interviewed in Mar 2021.Ā There were 3 interview rounds.

Interview QuestionnaireĀ 

1 Question

  • Q1. Related to my past skills and practical experience.
  • Ans. I explained which I was worked.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Please mention on resume which you have skills and experience only.

I applied via Campus Placement and was interviewed in Mar 2021.Ā There was 1 interview round.

Interview QuestionnaireĀ 

2 Questions

  • Q1. Introduction
  • Q2. Qualification, basic questions about customer service, empathy apology,how to handle angry customer..thats it

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be fluent in English and Hindi ..
Give some good and creative answers that's all..šŸ˜Š.

Interview QuestionnaireĀ 

2 Questions

  • Q1. No question asked
  • Q2. They call and said we will give 10k only

Interview Preparation Tips

Interview preparation tips for other job seekers - In pandamic i gave my interview so this would be reason that they didnt ask much question
Because of lockdown

Interview QuestionnaireĀ 

1 Question

  • Q1. Oops and. Net

I applied via Referral and was interviewed in Jul 2021.Ā There was 1 interview round.

Round 1 - TechnicalĀ 

Interview Preparation Tips

Interview preparation tips for other job seekers - If you're a java aspirant, prepare better for core java, java 8 & 11. Framework and upskilling can be done post joining. focus on java, collection framework and multithreading if you are 5-6 yrs experienced.

I applied via Company Website and was interviewed before May 2020.Ā There were 3 interview rounds.

Interview QuestionnaireĀ 

4 Questions

  • Q1. Take a topic by yourself and talk about 2 minutes about it.
  • Q2. How was your college life and what you have learned?
  • Q3. How you can associate with a team and how you can avoid misunderstandings
  • Q4. Tell me something about yourself?

Interview Preparation Tips

Interview preparation tips for other job seekers - Hello, guys im basically a middle class person with minimum knowledge in english but i have a hugh practice of talking since school days . So many people asking me that how can i speak fluently but the trick is that i do copy since many years . Well its not about how much you speak . The things how you speak ?



You dont need to use fancy words or any tough words . Just be simple and straight. Take a topic and try to me the other person understand that you can translate things clearly. Even if you're using butler english it should be simple . Nothing but make sure you need have 100% good typing speed . No compromise on it .

Interview QuestionnaireĀ 

1 Question

  • Q1. Prepare as per your cv

Interview QuestionnaireĀ 

3 Questions

  • Q1. They asked my previous development related question
  • Q2. Migrate mvc
  • Q3. Using of version control
  • Ans. 

    Version control is essential for managing code changes and collaborating with team members.

    • Version control allows for tracking changes made to code over time.

    • It enables collaboration between team members by allowing multiple people to work on the same codebase simultaneously.

    • It provides a way to revert to previous versions of code if necessary.

    • Popular version control systems include Git, SVN, and Mercurial.

  • Answered by AI

Skills evaluated in this interview

411 Locals Interview FAQs

What are the top questions asked in 411 Locals Technical Lead interview for experienced candidates?

Some of the top questions asked at the 411 Locals Technical Lead interview for experienced candidates -

  1. Which all control statements are there in the database? Why we need ...read more
  2. How to optimize SQL and databa...read more
  3. Prepare on basics of PHP and few logical code rel...read more

Tell us how to improve this page.

Technical Lead Interview Questions from Similar Companies

HCLTech Technical Lead Interview Questions
3.5
Ā ā€¢Ā 195 Interviews
Wipro Technical Lead Interview Questions
3.7
Ā ā€¢Ā 132 Interviews
Infosys Technical Lead Interview Questions
3.6
Ā ā€¢Ā 129 Interviews
Cognizant Technical Lead Interview Questions
3.7
Ā ā€¢Ā 58 Interviews
LTIMindtree Technical Lead Interview Questions
3.7
Ā ā€¢Ā 41 Interviews
TCS Technical Lead Interview Questions
3.7
Ā ā€¢Ā 35 Interviews
Accenture Technical Lead Interview Questions
3.8
Ā ā€¢Ā 23 Interviews
Capgemini Technical Lead Interview Questions
3.7
Ā ā€¢Ā 13 Interviews
View all
Executive Recruiter
4 salaries
unlock blur

ā‚¹11 L/yr - ā‚¹12.5 L/yr

Software Engineer
3 salaries
unlock blur

ā‚¹13.7 L/yr - ā‚¹17 L/yr

Accounts Manager
3 salaries
unlock blur

ā‚¹6.3 L/yr - ā‚¹6.3 L/yr

Digital Marketing Manager
3 salaries
unlock blur

ā‚¹17 L/yr - ā‚¹20 L/yr

Team Leader SEO
3 salaries
unlock blur

ā‚¹15 L/yr - ā‚¹15 L/yr

Explore more salaries
Compare 411 Locals with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview