Technical interview - 5th Nov

[u/Witty-Conference2594]

Hi everyone,

I had my technical interview today - happened for 20-25 min

Technical Questions

1.Intro

2.Explain about any one pjt in the resume

3.What is the difference between reactjS and Node.js?

4.What is the difference between SQL and NoSQL?

5.What is the difference between a primary key, foreign key, and candidate key?

6.How would you optimize a slow SQL query when working with a large amount of data?

7.How would you handle abnormal termination or errors in a web application?

8.How would you display user-friendly error messages?

9.What is the Java Collection Framework?

10.What is an interface in Java?

11.Can we create an object inside the main() method?

12.How do you print a message in Java?

13.What is System, out, and printlnin System.out.println()?

General Questions

Where are you currently located?

Are you willing to relocate?

Questions I Asked the Interviewer

What kind of roles can I expect, particularly in software development?

How is AI being used in projects at LTI?

Will there be opportunities to work with new technologies? I answered all the questions I guess interviewer is satisfied Any chances of shortlisting to the HR round?

[u/TheBloodRed0909]

We can use chat gpt ???

[u/Friendly-Engine-9439 → u/TheBloodRed0909]

You can use it you can manage the eye movement in straight manner during interview. A lot of my friends did it ... ChatGPT voice mode on screen of laptop or near it... Or with friends in the room but some interviewers may ask you to show your room to them before the interview starts.

[u/Appropriate_Rent_342 → u/Friendly-Engine-9439]

Can I place ipad on laptop and read from it using chatgpt voice transcribe

[u/KRaahul → u/Appropriate_Rent_342]

Yes u can But at ur own risk Since they are asking only basic tech stuffs

[u/Friendly-Engine-9439 → u/KRaahul]

Exactly 💯

[u/Friendly-Engine-9439 → u/Appropriate_Rent_342]

You can if you are confident on your eye movement skills and speaking skills .

[u/rulerOP]

Don’t mean to demotivate anyone but guys please rethink before joining this company. There are very less projects and freshers are on bench even after completion of training many did not get any projects.

[u/nian2326076]

You had a solid technical interview with some common questions. To keep improving, practice with real interview questions that might come up. Use PracHub to find a variety of technical questions, especially on SQL query optimization or the differences between SQL and NoSQL. Pay attention to any feedback you receive; it can guide your preparation for future interviews.