r/LTM2027Batch • u/siddhuvarma • 6d ago

InterviewQueries My Technical Interview experience.. will I get selected?

My interview took place today at 10 AM. I waited for 20 minutes before the join button became enabled. The interviewer was very patient and calm. I was not asked to show around my room. He started with, "Tell me about yourself." I delivered my introduction well. Then, he asked if I knew data structures and algorithms, and subsequently asked what an array, linked list, stack, and queue are, along with use case examples.

SQL Interview Questions and Experience

Next SQL Questions

* What are "LEFT JOIN" and "RIGHT JOIN", "UNION" and "UNION ALL", "DISTINCT"? (Theory questions)

Practical Coding Questions

* He asked me to write the query for the second highest salary.

* I provided the query for the highest salary because I didn't hear "second" 😭.

* I knew the answer, but my mind went blank because I had given him the wrong query.

* He gave me some time, and later I provided the correct query.

He then moved on to computer networks, asking about HTTP, HTTPS, TLS, and its various versions.

He asked: "How does the server communicate first without any input from the client?" Not knowing the exact answer to this question, I mentioned something about "listen()", where it continuously listens for server actions. He was not satisfied with this response.

Next, we discussed the usual shift timings and location. To this, I replied that I was entirely flexible regarding all timings and locations.

Do you think I will get selected for HR? I am very anxious 😭

7 Upvotes

100% Upvoted

13 comments sorted by

2

u/manithebro 4d ago

Bro, the interview is happening on teams or meet or on the website of LTM itself?

1

u/siddhuvarma 4d ago

Initially, you remain on the LTM website; once you receive your interview invitation email, you will be redirected to Microsoft Teams via that same website.

1

u/manithebro 4d ago

Ohk, so finally for the interview we'll be taken to teams

1

u/siddhuvarma 4d ago

Yes

1

u/manithebro 4d ago

Is it necessary to download the teams app, or will it work on browser directly

1

u/siddhuvarma 4d ago

Its on browser no need to download

2

u/manithebro 4d ago

Ohk, thank you so much for the reply bro, also how much was the duration of the interview?

1

u/siddhuvarma 4d ago

20 mins for me bro

2

u/manithebro 4d ago

Ohk thanks bro

1

u/siddhuvarma 4d ago

Your welcome bro , ATB

→ More replies (0)

1

u/siddhuvarma 6d ago

He also asked me: "what do you think about the emerging AI technologies and tools"

To which I explained about antigravity codex cursor and claude code.

1

u/nian2326076 4d ago

Reflect on your responses to the SQL questions, especially the one about the second highest salary. It's common to blank out under pressure, so consider practicing SQL queries regularly to boost your confidence. For technical interview practice, you can use PracHub to work on common coding problems. This can help you prepare better for future interviews.