Upload Button Icon Add office photos

Filter interviews by

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 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
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. All related to domain javascript/react,
  • Q2. Fallback in lazy loading,optimization techniques/for API call
  • Ans. 

    Fallback in lazy loading is important for optimizing API calls to ensure a smooth user experience.

    • Implementing a loading spinner or placeholder while content is being loaded asynchronously

    • Using a default value or cached data if the API call fails

    • Implementing error handling to gracefully handle any issues with the API call

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Some basic aptitude and quants questions were asked with 2 coding questions.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Basic questions on oops
  • Q2. Exception and exception handling
Round 3 - Gaming round 

(2 Questions)

  • Q1. Solve problems by using Function
  • Q2. Solve problems using loops
Round 4 - HR 

(1 Question)

  • Q1. Just basic hr questions
Round 5 - Behavioral 

(1 Question)

  • Q1. Reasoning questions
Interview experience
3
Average
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Not Selected

I applied via LinkedIn

Round 1 - HR 

(2 Questions)

  • Q1. Why do you want to work at EA
  • Q2. Describe a time you have a conflict
Round 2 - Technical 

(2 Questions)

  • Q1. What happens when you use a copy constructor in C++
  • Ans. 

    Using a copy constructor in C++ creates a new object by copying the values of another object.

    • Copy constructor is a special member function that creates a new object as a copy of an existing object.

    • It is invoked when a new object is created from an existing object.

    • Example: MyClass obj1; MyClass obj2 = obj1; // Copy constructor is called to create obj2 as a copy of obj1.

  • Answered by AI
  • Q2. When to use pointer/reference
  • Ans. 

    Pointers/references are used to pass memory addresses instead of values, for efficiency and to modify data directly.

    • Use pointers when you need to modify the original data passed to a function

    • Use references when you want to avoid copying large data structures

    • Pointers are commonly used in dynamic memory allocation

    • References are used in function parameters to avoid unnecessary copying

    • Example: int x = 10; int *ptr = &x; *p

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Python async db questions
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Basic output-based MCQs on Javascript and Typescript
Round 2 - Coding Test 

In depth OOPs concept, javascript and typescript based questions

Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - I gave 2 interviews. The first person who interviewed me asked questions as they were hiring for Google. The second time it was related to my projects and skills required for the role.

I applied via Referral and was interviewed in Nov 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. What are the attributes in html
  • Ans. 

    HTML attributes are used to provide additional information about HTML elements.

    • Attributes are added to HTML tags using the syntax 'attribute=value'

    • Attributes can be used to specify the appearance, behavior, or functionality of an element

    • Common attributes include 'class', 'id', 'src', 'href', 'alt', 'title', 'style', and 'target'

  • Answered by AI
  • Q2. What are the marquee tag used
  • Ans. 

    The marquee tag is used to create scrolling text or images on a web page.

    • The marquee tag is not recommended for use in modern web development.

    • It can be used to create a scrolling banner or ticker on a webpage.

    • The tag has attributes such as direction, behavior, and scrollamount.

    • Example: Scrolling text here

  • Answered by AI
  • Q3. What are the comments of html
  • Ans. 

    HTML comments are used to add notes or explanations to the code that are not displayed in the browser.

    • Comments start with

    • Comments can be used to temporarily remove code from the page

    • Comments can also be used to add notes for other developers working on the code

    • Comments do not affect the display of the page

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was a technical one but was majorly a stress test.

Skills evaluated in this interview

I was interviewed before Sep 2020.

Interview Questionnaire 

2 Questions

  • Q1. 1. Oops concepts 2. Memory leakage 3. Typescript questions 4. Eslint , jslint 5. General technology based questions 6. Previous project details.
  • Q2. 7. Canvas 8. Graphics

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Be confident
2. Don't hesitate
3. Ask if something not clear
4. They give you complete space and time to response.
5. Do not hurry
6. They help too , if get stuck.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Internshala and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

An aptitude and coding test conducted simultaneously.

Round 2 - Technical 

(1 Question)

  • Q1. What is the Fibonacci series?
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Layouts, Position, And Grid layout

Round 2 - Technical 

(5 Questions)

  • Q1. Different between Undefined Null
  • Ans. 

    Undefined is a variable that has not been assigned a value, while null is a variable that has been explicitly assigned a value of null.

    • Undefined is the default value of a variable that has not been initialized.

    • Null is an explicit value that can be assigned to a variable to indicate that it has no value.

    • Undefined is a type in JavaScript, while null is a value of the Null type.

    • Example: let x; // x is undefined, let y = n

  • Answered by AI
  • Q2. Functions and Reverse String
  • Q3. Different between position's property
  • Ans. 

    The position property in CSS specifies the positioning method of an element.

    • Static: Default positioning, elements are positioned according to the normal flow of the document.

    • Relative: Positioned relative to its normal position.

    • Absolute: Positioned relative to the nearest positioned ancestor.

    • Fixed: Positioned relative to the viewport.

    • Sticky: Acts like a combination of relative and fixed positioning.

  • Answered by AI
  • Q4. Different between Grid Flex box layout
  • Ans. 

    Grid layout is a two-dimensional layout system while Flexbox is a one-dimensional layout system.

    • Grid layout is best for overall page layout, while Flexbox is best for aligning items within a container.

    • Grid layout allows for precise placement of elements in rows and columns, while Flexbox is more flexible in arranging items in a single row or column.

    • Grid layout is better suited for complex layouts with multiple rows and...

  • Answered by AI
  • Q5. What is arrays explain the array
  • Ans. 

    Arrays are a data structure that stores a collection of elements of the same data type in a contiguous memory location.

    • Arrays have a fixed size determined at the time of declaration.

    • Elements in an array are accessed using an index starting from 0.

    • Arrays can store primitive data types like integers, floats, or objects like strings.

    • Example: var fruits = ['apple', 'banana', 'orange'];

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stik with basic of Javascript deep knowledge of HTML CSS

Skills evaluated in this interview

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, HR and Resume Shortlist.
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

Tell us how to improve this page.

Interview Questions from Similar Companies

Jio Interview Questions
3.9
 • 1.6k Interviews
Pole To Win Interview Questions
3.5
 • 52 Interviews
Dream11 Interview Questions
3.8
 • 37 Interviews
Disney+ Hotstar Interview Questions
3.8
 • 32 Interviews
Light & Wonder Interview Questions
3.8
 • 29 Interviews
PurpleTalk Interview Questions
3.9
 • 26 Interviews
Electronic Arts Interview Questions
4.2
 • 22 Interviews
View all

Fast track your campus placements

View all
Senior Associate
56 salaries
unlock blur

₹3.1 L/yr - ₹12 L/yr

Associate Manager
44 salaries
unlock blur

₹7 L/yr - ₹18.6 L/yr

Associate
40 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Junior Associate
31 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Associate Product Manager
20 salaries
unlock blur

₹5 L/yr - ₹11 L/yr

Explore more salaries
Compare Sportz Interactive with

Dream11

3.8
Compare

Cricbuzz

3.2
Compare

Disney+ Hotstar

3.8
Compare

Star Sports

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