Deltatech Gaming Business Analyst Interview Questions and Answers

Different question were asked on sql python java

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

Easy coding questions

Tough level questions , needed high level of thinking

SQL based leetcode medium and hackerrank

Python take home EDA case study assessment

Q1. SQL on joins , partition, rank dense rank
Add your answer
Q2. Case study on guestimation
Add your answer

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

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

Three coding online assessments - screening round.

Two to three coding questions based on dynamic programming.

Q1. Resume based and computer network
Add your answer

Q1. Simple hr question
Add your answer