Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Sportz Interactive DB Developer Interview Questions and Answers

Updated 1 Feb 2024

Sportz Interactive DB Developer Interview Experiences

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 Resume 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

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Coding Test 

HACKERANK CODING TEST

Round 2 - One-on-one 

(1 Question)

  • Q1. BASIC STUFF ABOUT DBMS, OOPS, SYSTEM DESIGN
Round 3 - Assignment 

MACHINE LEARNING - HAD TO DESIGN ONE OF CRICBUZZ FEATURE

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Coding Test 

The interview primarily centered around core Java concepts, including exception handling, Java streams, and collections. The coding question was related to binary search.

Interview Preparation Tips

Interview preparation tips for other job seekers - Ensure that you have a strong understanding of core Java concepts, particularly the features introduced in Java 8.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackerrank test on dsa and some mcq questions

Round 2 - Assignment 

Machine coding round on some Cricbuzz functionality

Round 3 - Technical 

(1 Question)

  • Q1. Techinical interview on machine coding
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Initially first was HackerRank assessment then first round was of DSA. Asked 3 questions
1) Find max sum of substrings of length k
2) Find whether 2 strings are anagram or not
3) There is a Array and Find the max sum of subsequence. If you take element index at 1 in array then you are not suppose to take element index at 0 & 2 -> I solved it with Recursion then applied DP.

Cracked Round 1.

Round 2 - Assignment 

This was a machine coding round where I have to create 3 API of Cricbuzz feature.
1) Post API which will take Match Details and we have to create points table like we have in IPL
2) Get API to fetch Point table based on total Points
3) Get API to fetch last 3 matchs of a team and there results.

Round 3 - Assignment 

This was Code review round. Interviewer first asked about my project in my current company and multiple questions like hiw many team member and how many juniors u are handling. Then we move to code review and he checked extensibility of code by asking if I have to add year wise point table then How will you add then If there are many Tournament then how you will implement.

Interview Preparation Tips

Interview preparation tips for other job seekers - Write extensible code in machine coding round & create good project structure, DB design & Refactored code.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Relationship with customer discussion

Interview experience
4
Good
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 4 Coding question to be solve live

I applied via Company Website and was interviewed before Aug 2021. 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 Resume tips
Round 2 - Coding Test 

45 mins, Purely on DSA - Arrays, Strings, LinkedList, Trees

Round 3 - Technical 

(1 Question)

  • Q1. System design round with focus on scalability
Round 4 - Technical 

(1 Question)

  • Q1. Bar Raiser Round with focus on company culture and employee alignment
Round 5 - HR 

(1 Question)

  • Q1. Salary discussion and culture fit round

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basics and have the curiosity to learn. Please go through the company culture website and align your answers based on the culture.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Experience in fields
  • Q2. Expected and current ctc
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Three coding online assessments - screening round.

Round 2 - Coding Test 

Two to three coding questions based on dynamic programming.

Round 3 - Technical 

(1 Question)

  • Q1. Resume based and computer network
Round 4 - HR 

(1 Question)

  • Q1. Simple hr question

Interview Preparation Tips

Interview preparation tips for other job seekers - If clear coding is improved, the chances of being selected will increase.
Contribute & help others!
anonymous
You can choose to be anonymous

Sportz Interactive Interview FAQs

How many rounds are there in Sportz Interactive DB Developer interview?
Sportz Interactive interview process usually has 5 rounds. The most common rounds in the Sportz Interactive interview process are Technical, Resume Shortlist and Coding Test.
What are the top questions asked in Sportz Interactive DB Developer interview?

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

  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

Recently Viewed

INTERVIEWS

Kyndryl

No Interviews

SALARIES

Sportz Interactive

SALARIES

TSS Consultancy

INTERVIEWS

Kyndryl

No Interviews

INTERVIEWS

TSS Consultancy

No Interviews

LIST OF COMPANIES

Acty System India

Locations

INTERVIEWS

Fable Fintech

No Interviews

SALARIES

TSS Consultancy

SALARIES

Fable Fintech

INTERVIEWS

Acty System India

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

Jio Interview Questions
3.9
 • 1.7k Interviews
Pole To Win Interview Questions
3.4
 • 57 Interviews
Aristocrat Interview Questions
3.8
 • 45 Interviews
Dream11 Interview Questions
3.8
 • 36 Interviews
Disney+ Hotstar Interview Questions
3.7
 • 36 Interviews
Light & Wonder Interview Questions
3.9
 • 29 Interviews
Electronic Arts Interview Questions
4.1
 • 22 Interviews
IDZ Digital Interview Questions
3.8
 • 22 Interviews
View all

Fast track your campus placements

View all
Senior Associate
59 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
41 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
41 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Associate
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Product Manager
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Sportz Interactive with

Dream11

3.8
Compare

Cricbuzz

3.1
Compare

Disney+ Hotstar

3.7
Compare

Star Sports

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