Find Interview Questions for Cians analytics

Right Answer:
Input Context Operators are used to define the context for input data in a query, while Output Context Operators are used to specify how the results of a query should be formatted or presented.

Right Answer:
Data objects are instances of data structures that represent and encapsulate data in a specific format, allowing for organized storage, retrieval, and manipulation of that data within a database or application.

Right Answer:
A magic table in SQL Server refers to the special tables created by the system during the execution of triggers. When a trigger is fired, SQL Server creates a copy of the affected rows in these magic tables, named inserted and deleted, allowing you to access the new and old values of the rows being modified.

When you run any command or stored procedure, it is compiled into an execution plan before being executed. This compilation process optimizes the query for performance.

Right Answer:
A Primary Key is a unique identifier for a record in a table, ensuring that no two rows have the same value in that column. An Aggregate Key, on the other hand, is a combination of two or more columns used together to uniquely identify a record, often used in scenarios where a single column is not sufficient to ensure uniqueness.

Right Answer:
A deadlock in SQL Server occurs when two or more transactions are waiting for each other to release locks on resources, creating a cycle of dependencies that prevents any of the transactions from proceeding. SQL Server automatically detects deadlocks and resolves them by terminating one of the transactions, allowing the other to continue.

Right Answer:
Django is a high-level web framework that follows the "batteries-included" philosophy, providing many built-in features like an ORM, admin panel, and authentication. Pyramid is a flexible framework that allows developers to choose components and is suitable for both small and large applications. Flask is a micro-framework that is lightweight and simple, focusing on minimalism and allowing developers to add extensions as needed.

Right Answer:
NumPy is a powerful library in Python used for numerical computing. It provides support for large, multi-dimensional arrays and matrices, along with a collection of mathematical functions to operate on these arrays. NumPy is better than a list in Python because it offers faster performance for numerical operations, requires less memory, and provides a wide range of mathematical functions that are optimized for array operations.

Right Answer:
You can check the version of Django by running the following command in your terminal:

```bash
python -m django --version
```

Alternatively, you can check it in a Python shell with:

```python
import django
print(django.get_version())
```

Right Answer:
Defect Rejection Ratio (DRR) is the percentage of defects that are rejected during the testing process, indicating the effectiveness of the testing team in identifying valid defects. It is calculated as:

[ text{DRR} = frac{text{Number of rejected defects}}{text{Total number of defects}} times 100 ]

Defect Leakage Ratio (DLR) is the percentage of defects that escape the testing phase and are found after the product is released, indicating the quality of the testing process. It is calculated as:

[ text{DLR} = frac{text{Number of defects found after release}}{text{Total number of defects}} times 100 ]

Right Answer:
TD (Test Director) is a test management tool used for planning, executing, and tracking testing activities, while QC (Quality Center) is a more advanced version that includes additional features for managing the entire quality assurance process, including requirements management, defect tracking, and reporting.

Right Answer:
The achievement of a plant improvement point can vary widely depending on specific goals, processes, and metrics used for evaluation. Typically, it is measured through key performance indicators (KPIs) such as yield, efficiency, and defect rates.

Right Answer:
Yes, I can handle all QC responsibilities, including developing quality standards, conducting inspections, analyzing data, and implementing improvements.

Right Answer:
Yes, discovery methods produce data that can inform and improve the policy, management, and operational aspects of the program by identifying areas for enhancement and guiding decision-making.