Find Interview Questions for JustDial

Right Answer:
To implement social login authentication in Django, you can use the `django-allauth` package. Here are the steps:

1. Install `django-allauth`:
```bash
pip install django-allauth
```

2. Add `allauth`, `allauth.account`, and `allauth.socialaccount` to your `INSTALLED_APPS` in `settings.py`:
```python
INSTALLED_APPS = [
...
'django.contrib.sites',
'allauth',
'allauth.account',
'allauth.socialaccount',
...
]
```

3. Set the `SITE_ID` in `settings.py`:
```python
SITE_ID = 1
```

4. Include the authentication backends in `settings.py`:
```python
AUTHENTICATION_BACKENDS = (
...
'allauth.account.auth_backends.AuthenticationBackend',
)
```

5. Add URL

Right Answer:
In Django, you can use the `annotate()` and `values()` methods to perform a group by query. Here's an example:

```python
from django.db.models import Count
from your_app.models import YourModel

result = YourModel.objects.values('field_to_group_by').annotate(count=Count('id'))
```

This will group the records by `field_to_group_by` and count the number of occurrences for each group.

Right Answer:
To use file-based sessions in Django, set the session engine in your `settings.py` file by adding or modifying the following line:

```python
SESSION_ENGINE = 'django.contrib.sessions.backends.file'
```

Make sure to also specify the directory where session files will be stored by setting:

```python
SESSION_FILE_PATH = '/path/to/your/session/files'
```

Django will then use files in the specified directory to store session data.

Right Answer:
To optimize stored procedures, you can:

1. **Use Proper Indexing**: Ensure that the tables involved have appropriate indexes to speed up data retrieval.
2. **Avoid Cursors**: Replace cursors with set-based operations whenever possible.
3. **Minimize Data Retrieval**: Select only the necessary columns and rows to reduce the amount of data processed.
4. **Use Temporary Tables**: Utilize temporary tables to store intermediate results if needed.
5. **Analyze Execution Plans**: Review execution plans to identify bottlenecks and optimize queries accordingly.
6. **Parameter Sniffing**: Use `OPTION (RECOMPILE)` for queries that perform poorly with parameter sniffing.
7. **Avoid Functions on Indexed Columns**: Avoid using functions on indexed columns in the WHERE clause, as it can prevent index usage.
8. **Batch Processing**: Break large operations into smaller batches to reduce locking and improve performance.
9. **Update Statistics**: Regularly update statistics to ensure

Right Answer:
Modicare, officially known as Ayushman Bharat, provides a broader health coverage of up to ₹5 lakh per family per year for secondary and tertiary care hospitalization, while Rashtriya Swasthya Bima Yojana (RSBY) primarily focuses on providing health insurance to below-poverty-line families for specific health services.

Right Answer:
To remove duplicate records from a table in SQL Server, you can use a Common Table Expression (CTE) with the `ROW_NUMBER()` function. Here’s an example query:

```sql
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY (SELECT NULL)) AS rn
FROM your_table
)
DELETE FROM CTE WHERE rn > 1;
```

Replace `column1`, `column2` with the columns that define duplicates, and `your_table` with the name of your table.

Right Answer:
Success in Agile is measured by:

* **Output:** Delivering valuable, working software frequently; achieving the product vision; meeting business goals; customer satisfaction; and predictability (consistent delivery).
* **Team Health:** Team morale; continuous improvement (velocity trends, retrospectives leading to action); collaboration; self-organization; and sustainable pace.

Right Answer:
Agile ceremonies are recurring meetings within a sprint to facilitate communication, planning, and continuous improvement.

* **Sprint Planning:** The team decides what work to complete in the upcoming sprint. They discuss user stories, estimate effort, and define the sprint goal.

* **Daily Stand-up:** A brief daily meeting where the team shares progress, identifies roadblocks, and coordinates efforts. Each member typically answers: What did I do yesterday? What will I do today? Are there any impediments?

* **Sprint Review:** The team demonstrates the completed work to stakeholders, gathering feedback and ensuring alignment with expectations.

* **Sprint Retrospective:** The team reflects on the past sprint, identifying what went well, what could be improved, and defining action items to enhance future performance.

Right Answer:
A sprint backlog is a detailed plan of work for a specific sprint, derived from the product backlog. It's created during sprint planning by the development team, who select items from the product backlog they commit to complete, then break down those items into tasks and estimate the effort required for each.

Right Answer:
I've used tools like Jira, Azure DevOps, and Trello for Agile project management. I choose them based on project needs; Jira for complex workflows and robust reporting, Azure DevOps for integrated development environments, and Trello for simpler, visually-oriented task management.

Right Answer:
A product backlog is a prioritized list of features, bug fixes, tasks, and requirements needed to build a product. It's managed through regular refinement, prioritization, estimation, and updates based on feedback and changing business needs, often facilitated by the Product Owner.