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 === ?
