GSPANN Technologies Python Developer Intern Interview Questions and Answers

Q1. SQL database questions
Add your answer

Q1. About Selenium Xpath
Add your answer
Q2. About Pytest fixtures
Add your answer
Q3. SQL distinct and count
Add your answer

Q1. Past project related questions
Add your answer
Q2. Python and sql queries
Add your answer

Waiting for l2 round

Simple python programming concepts

Q1. Basic System design of inter service communication in transactional systems.
Ans. 
Inter service communication in transactional systems involves designing a reliable and efficient way for services to communicate and exchange data.
• Use asynchronous messaging systems like RabbitMQ or Kafka to decouple services and ensure reliable message delivery.

• Implement RESTful APIs for synchronous communication between services, using HTTP methods like GET, POST, PUT, DELETE.

• Consider using gRPC for high-performance,...read more
Answered by AI
Add your answer
Q2. Loading and processing a file with huge data volume
Ans. 
Use pandas library for efficient loading and processing of large files in Python.
• Use pandas read_csv() function with chunksize parameter to load large files in chunks.

• Optimize memory usage by specifying data types for columns in read_csv() function.

• Use pandas DataFrame methods like groupby(), merge(), and apply() for efficient data processing.

• Consider using Dask library for parallel processing of large datasets.

• Use gen...read more
Answered by AI
Add your answer

Q1. What is List Comprehension
Ans. 
List comprehension is a concise way to create lists in Python by iterating over an existing list or iterable.
• Syntax: [expression for item in iterable]

• Can include conditions: [expression for item in iterable if condition]

• Can be nested: [[i*j for j in range(1, 4)] for i in range(1, 4)]

• Can be used to create new lists from existing lists efficiently
Answered by AI
Add your answer
Q2. What are the types of Serializers in Django
Ans. 
Types of Serializers in Django include ModelSerializer, Serializer, and HyperlinkedModelSerializer.
• ModelSerializer: Used to serialize Django model instances.

• Serializer: Generic serializer class for custom data serialization.

• HyperlinkedModelSerializer: Includes hyperlinks to related resources in the serialized data.
Answered by AI
Add your answer

Q1. Create linkedList
Ans. 
A linked list is a data structure consisting of nodes where each node points to the next node in the sequence.
• Create a Node class with data and next pointer

• Create a LinkedList class with methods like insert, delete, search

• Example: Node class - class Node: def __init__(self, data): self.data = data self.next = None
Answered by AI
Add your answer
Q2. Basic to advance python
Add your answer