Upload Button Icon Add office photos

Filter interviews by

Sportz Interactive DB Developer Interview Questions and Answers for Experienced

Updated 1 Feb 2024

Sportz Interactive DB Developer Interview Experiences for Experienced

1 interview found

DB Developer Interview Questions & Answers

user image Anonymous

posted on 13 Dec 2022

I applied via LinkedIn and was interviewed in Feb 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Question received for writing query in sql server ,mostly question related of sports data.

Round 3 - Technical 

(1 Question)

  • Q1. 1.what is sql server 2.what is procedure 3.what is CTE table 4. Difference between cte and table variable in sql 5. Difference between function and procedure. 6.type of indexes 7.what is unique index.
  • Ans. 

    SQL Server is a relational database management system developed by Microsoft.

    • SQL Server is a software product used to manage and store data in a relational database.

    • It provides a platform for creating, managing, and querying databases.

    • SQL Server supports SQL (Structured Query Language) for interacting with the database.

    • It offers various features like data storage, data retrieval, data manipulation, and data security.

    • SQ...

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. 1 what is view 2 difference between union and union all. 3.what is indexes 4.difference between primary and unique key. 5.what is composit key.
  • Ans. 

    A view is a virtual table that is based on the result of a query. It is used to simplify complex queries and provide a logical representation of data.

    • Views are created by selecting columns from one or more tables and can be used like a table in queries.

    • They do not store any data themselves but provide a way to access and manipulate data from underlying tables.

    • Views can be used to restrict access to certain columns or r...

  • Answered by AI
Round 5 - HR 

(1 Question)

  • Q1. 1.introduction and experience 2.favorite game 3.favorite player

Interview Preparation Tips

Interview preparation tips for other job seekers - Give answer in simple and suitable words, don't try show advance infront of interviewer, only give answer of his question.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Data Structures, Design, Strings, Bit

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with all data structures, know your design and algorithms.

Interview Questionnaire 

2 Questions

  • Q1. Palindrome
  • Q2. Study basic coding

Interview Questionnaire 

1 Question

  • Q1. Leetcode medium questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare top leetcode questions

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Coding Test 

General coding questions

Round 2 - Technical 

(1 Question)

  • Q1. Related technical question

Interview Preparation Tips

Interview preparation tips for other job seekers - Mid level company, salary is not upto market. Rest is fine.

I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions were mostly asked on SQL, Python libraries, Machine learning and Excel, puzzles to solve before interview there was test case study to solve.
  • Q2. What is row number, rank, dense rank? explain partition by, indexing joins, query optimization techniques
  • Ans. 

    Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.

    • Row number is a function that assigns a unique number to each row in a result set.

    • Rank is a function that assigns a rank to each row based on the values in a specified column.

    • Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.

    • Partit...

  • Answered by AI
  • Q3. Real-time examples on data analytics with examples
  • Ans. 

    Real-time examples of data analytics

    • Predictive maintenance in manufacturing

    • Real-time fraud detection in banking

    • Personalized recommendations in e-commerce

    • Real-time traffic analysis for smart cities

    • Real-time health monitoring in medical devices

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Basic questions on react js, also question related to data structure and sorting algorithm

I applied via Walk-in and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Link list program, few objective based on cpp

Round 2 - One-on-one 

(2 Questions)

  • Q1. Good Core knowledge cpp
  • Q2. Pointer, static , constant used in multiple scenario. Oops, STL

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well practically, work culture and pay is good!!
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via IIM Jobs and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Coding Test 

SQL Coding Test - asked 5 queries related to joins, ranks, group by

Round 2 - Case Study 

Asked guesstimates, technical CV Question, case

Round 3 - Case Study 

Asked guesstimate, market entry question, case

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Coding Test 

3 online dsa questions easy to medium

Sportz Interactive Interview FAQs

How many rounds are there in Sportz Interactive DB Developer interview for experienced candidates?
Sportz Interactive interview process for experienced candidates usually has 5 rounds. The most common rounds in the Sportz Interactive interview process for experienced candidates are Technical, HR and Resume Shortlist.
How to prepare for Sportz Interactive DB Developer interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sportz Interactive. The most common topics and skills that interviewers at Sportz Interactive expect are Cobol, DBMS, Data Warehousing, Database Design and Database Development.
What are the top questions asked in Sportz Interactive DB Developer interview for experienced candidates?

Some of the top questions asked at the Sportz Interactive DB Developer interview for experienced candidates -

  1. 1.what is sql server 2.what is procedure 3.what is CTE table 4. Difference be...read more
  2. 1 what is view 2 difference between union and union all. 3.what is indexes 4...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Pole To Win Interview Questions
3.4
 • 58 Interviews
Aristocrat Interview Questions
3.9
 • 47 Interviews
Light & Wonder Interview Questions
3.9
 • 29 Interviews
Electronic Arts Interview Questions
4.1
 • 23 Interviews
IDZ Digital Interview Questions
3.8
 • 22 Interviews
Games24x7 Interview Questions
3.7
 • 19 Interviews
View all

Fast track your campus placements

View all
Associate Manager
64 salaries
unlock blur

₹7.5 L/yr - ₹16 L/yr

Senior Associate
59 salaries
unlock blur

₹3.2 L/yr - ₹13.6 L/yr

Associate
41 salaries
unlock blur

₹2.4 L/yr - ₹8 L/yr

Junior Associate
31 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Senior Manager Project Management
21 salaries
unlock blur

₹13.4 L/yr - ₹15 L/yr

Explore more salaries
Compare Sportz Interactive with

Pole To Win

3.4
Compare

International Game Technology

3.2
Compare

Ubisoft Entertainment

3.8
Compare

Aristocrat

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview