LS Digital interview questions

Total 3 interviews till now 1 more to go 1st technical interview: a)Tell me about yourself b) javascript objects syntax ? c) ways to access the properties of objects in js? d)What is SQL? e)What are joins? f) Explain inner left and right join g) A employee table is given they will tell you write a query to do some task Write a query to fetch first name and last and concat them ? Query to get user where name is not Sanjay or Sonia h) what is DOM ? i) How to get an element using js write the syntax 2nd Round: 1. Tell me about yourself 2. Tell me about the projects 3. Situational question about bank crowd management 4. What libraries you used in your project 3rd round: 1. Situational questions 2. Questions about analytics 3. About previous roles or internship 4. Details about projects and what was the approach Riya Singh Tell me about yourself ? Final year project your role in project Which language know more java , python rate What is AWS ? AWS version AWS other Features Why is Java a platform? independent? OOPS in Java Difference between abstraction & encapsulation List and tuple in python Immutable mutable in python Dictionary is mutual or immutable? Decorators in python Shallow copy and deep copy in python Lamba function Difference b/w x range and range What is SQL What is joins Types of joins explain Where and have clause difference Normalisation Primary key Unique constraints Subquery Delete and truncate in sql What is ML ? Shubham Nagpure Round 1 Questions - LS Digital 1. Tell me about yourself 2. asked question based on projects you have done in resume 3. Explain Final year project and Tech stack used (explain the flow of project) 4. Rate yourself in Java, Javascript and SQL 5. Javascript object syntax 6. what is sql 7. What is DDL DML DCL explain all the commands used 8. what is difference between where and having clause 9. what is group by clause and where it is used 10. what are joins in sql 11. What is left join, right join and full outer join\ 12. What is union 13. What is null values in sql 14. Syntax of Update command in sql 15. Difference between Delete and truncate 16. What is subquery and explain with example 17. What are the aggregate functions 18. What is primary key and what if we doesn’t define the primary key in table ? 19. Can we join the table without primary key ? 20. What are the data types in JS? 21. What are promises in JS 22. what is clause function in JS ? 23. What is difference between var, let and const keyword in JS? 24. What are your strength and weaknesses? 25. What is hoisting in JS? 26. What is normalization in SQL 27. Explain 1NF, 2NF, 3NF 28. What is unique keyword in sql ? 29. What is mutable and immutable ? 30. What is ML ? 31. What is constructor in Java? 32. What is difference between == and === ?