Lloyds Technology Centre Senior Data Engineer Interview Questions and Answers

Q1. What are hooks, event loop usecontext api
Add your answer
Q2. What is aggregator
Add your answer

Jsjwkqnsnns.hejwkqp hsowpa bsoqla bspam

Bsppq hspals bsoak nspal bdoa a

Hsoaks bspapa bosoaks bospmwa bosoebs

Q1. Jspwpaknsbe jsos heopw
Add your answer
Q2. Jsppq jepwl jspam
Add your answer

Hdosm jspwl jspwla bqiq heowwo hsowoa

Q1. Hslwla jwpwpq belwp
Add your answer
Q2. Bspwlw noslw nspq a
Add your answer

Q1. Python basic codes
Add your answer
Q2. SQL query of aggregate function
Ans. 
SQL query using aggregate functions to perform calculations on a dataset
• Use aggregate functions like SUM, AVG, COUNT, MIN, MAX to perform calculations on a dataset

• Group data using GROUP BY clause to apply aggregate functions on specific groups

• Filter data using HAVING clause after applying aggregate functions
Answered by AI
Add your answer

1 hour 10 mins, MERN Stack, Face to Face. Mongodb, medium DSA Question, callback, eventloop, NodeJS asynchronous working

Q1. Technical.purely
Add your answer

Q1. Purely tech..and then you present a dashboard on power bi
Add your answer

Q1. NANANANANANANANA
Add your answer
Q2. NANANANANANANANANA
Add your answer

Q1. NANANANAANANANA
Add your answer
Q2. NANANANANANANANANANA
Add your answer

Low-level design interview
I need to design a Music player app using oops concept

Q1. Sort the stack in O(1) time complexity
Ans. 
Use an additional stack to store sorted elements and maintain the minimum element at the top of the original stack.
• Create a new stack to store sorted elements.

• Pop elements from the original stack and compare with the top element of the new stack.

• If the popped element is smaller, push it to the new stack. If larger, keep popping from the new stack and push to the original stack until the correct position is found.

• Repeat...read more
Answered by AI
View 1 more answer
Q2. Difference between process and thread
Ans. 
A process is an instance of a program running on a computer, while a thread is a smaller unit of execution within a process.
• A process has its own memory space, while threads within the same process share memory.

• Processes are independent of each other, while threads within the same process can communicate with each other.

• Processes are heavyweight, requiring separate memory and resources, while threads are lightweight an...read more
Answered by AI
Add your answer
Q3. Difference between abstract class and interface
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructor, fields, and methods, while interface cannot have any of these.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Abstract class is used to provide a common base for multiple derived classes, while interface is used to define a contract fo...read more
Answered by AI
Add your answer
Q4. What is race condition?
Ans. 
A race condition is a situation in which the outcome of a program depends on the order of execution of its threads or processes.
• Occurs when multiple threads or processes access shared data or resources concurrently

• Can lead to unpredictable behavior or bugs in the program

• Prevented by using synchronization mechanisms like locks or semaphores

• Example: Two threads trying to increment a shared variable simultaneously
Answered by AI
Add your answer
Q5. What is normalization in dbms
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured way.

• There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.

• Example: In a database of students, instead of storing student details in multiple ...read more
Answered by AI
Add your answer