Deltatech Gaming Customer Retention Executive Interview Questions and Answers

Different question were asked on sql python java

There were two coding questions; one was related to linked lists, and the other was linked to binary trees.

Q1. Can you elaborate on the project discussion you mentioned in your resume?
Ans. 
Developed a web application for tracking inventory and sales data
• Used React for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database management

• Integrated authentication and authorization features for secure access

• Implemented data visualization using Chart.js
Answered by AI
Add your answer
Q2. Can you provide the code to reverse a linked list?
Ans. 
Reversing a linked list involves changing the direction of pointers to go from the end to the beginning.
• Start by initializing three pointers: current, previous, and next.

• Iterate through the linked list, updating the pointers to reverse the direction of the links.

• Update the head of the linked list to point to the new first node, which was the original last node.
Answered by AI
Add your answer
Q3. Some questions were asked regarding the four pillars of Object-Oriented Programming (OOP)?
Add your answer
Q4. Questions related to pointers, dangling pointers.
Add your answer

Q1. Program for finding the perfect squares between two numbers.
Ans. 
Program to find perfect squares between two numbers
• Iterate through numbers between the given range

• Check if the square root of the number is an integer

• If yes, then it is a perfect square
Answered by AI
Add your answer
Q2. What are smart pointers in C++?
Ans. 
Smart pointers in C++ are objects that act like pointers but provide automatic memory management.
• Smart pointers help prevent memory leaks by automatically managing memory allocation and deallocation.

• Examples include unique_ptr, shared_ptr, and weak_ptr.

• unique_ptr is used for exclusive ownership, shared_ptr for shared ownership, and weak_ptr to prevent circular references.
Answered by AI
Add your answer
Q3. What is mutual exclusion in the context of concurrent programming?
Ans. 
Mutual exclusion is a concept in concurrent programming where only one thread can access a shared resource at a time.
• Ensures that only one thread can access a critical section of code at a time

• Prevents race conditions and data corruption

• Commonly implemented using locks, semaphores, or mutexes

• Example: Using a mutex to protect a shared variable in a multi-threaded application
Answered by AI
Add your answer
Q4. What is the process for implementing multithreading?
Ans. 
Implementing multithreading involves creating and managing multiple threads to execute tasks concurrently.
• Identify the tasks that can be executed concurrently

• Create and manage multiple threads to execute these tasks simultaneously

• Use synchronization techniques like locks and semaphores to prevent race conditions

• Handle communication and coordination between threads

• Consider thread safety and resource sharing issues
Answered by AI
Add your answer

Basic aptitude test, if you know basic maths you can easily crack it.

Easy coding questions

Tough level questions , needed high level of thinking

DSA, problem solving

System design interview and prior experience in projects

Q1. What was the toughest problem you encountered in your previous assignments ?
Add your answer
Q2. Given a choice, what would you have done differently in your previous assignments ?
Add your answer

Q1. Details about the projects in your resume
Add your answer
Q2. MYSQL codes in window function
Ans. 
MYSQL window functions allow for calculations across rows in a result set.
• Window functions are used to perform calculations across rows in a result set

• They are used with the OVER() clause

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They can be used to calculate running totals, moving averages, and more
Answered by AI
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced Senior Software Engineer with a passion for problem-solving and creating innovative solutions.
• Over 8 years of experience in software development

• Proficient in multiple programming languages such as Java, Python, and C++

• Strong background in designing and implementing scalable systems

• Led successful projects such as developing a real-time data analytics platform for a Fortune 500 company
Answered by AI
Add your answer
Q2. About techstacks
Add your answer