Sportz Interactive Interview Questions, Process, and Tips

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

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...read more
Answered by AI
Add your answer

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...read more
Answered by AI
Add your answer

Q1. 1.introduction and experience 2.favorite game 3.favorite player
Add your answer

Dont know why they need aptitude on such exp level

Q1. Related to API testing, manual testing
Add your answer

Q1. What is object oriented programming
Ans. 
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code to manipulate that data.
• Objects are instances of classes, which define the structure and behavior of the objects.

• Encapsulation is a key principle, where data is kept private within the object and only accessible through methods.

• Inheritance allows classes to inherit attributes and methods from other cla...read more
Answered by AI
Add your answer
Q2. What is static Constructor?
Ans. 
Static constructor is a special type of constructor in a class that is called only once when the class is loaded into memory.
• Static constructor is used to initialize static data members of a class.

• It is automatically called by the .NET Framework when the class is first loaded.

• Static constructor does not take any parameters and cannot be called explicitly.

• Example: public class MyClass { static MyClass() { // initializat
Answered by AI
Add your answer
Q3. What are solid Principles
Ans. 
SOLID principles are a set of five design principles that help make software designs more understandable, flexible, and maintainable.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects o...read more
Answered by AI
Add your answer
Q4. What is dependency injection
Ans. 
Dependency injection is a design pattern in which components are given their dependencies rather than creating them internally.
• Allows for easier testing by providing mock dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Commonly used in frameworks like Spring in Java
Answered by AI
Add your answer

What is static Constructor

Q1. Ghjgbj fhcd. 6tcjsv. D ear ink uchi c ya Ashu
Add your answer
Q2. Gg way you thi to get GB GT rhi ini ya en GB
Add your answer