CMS IT Services Python Developer Trainee 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. Difference between List and Array
Ans. 
List is a built-in Python data structure that can hold elements of different data types, while Array is a data structure from the NumPy library that can hold elements of the same data type.
• List is a dynamic array that can grow or shrink in size, while Array has a fixed size.

• List can hold elements of different data types, while Array can only hold elements of the same data type.

• List is a part of Python's standard librar...read more
Answered by AI
Add your answer
Q2. Types of renderer classes in DRF
Ans. 
DRF provides JSON, BrowsableAPI, TemplateHTML, and AdminRenderer classes for rendering responses.
• JSONRenderer: Renders data in JSON format.

• BrowsableAPIRenderer: Renders data in a browsable HTML format with forms for interacting with the API.

• TemplateHTMLRenderer: Renders data using a specified template in HTML format.

• AdminRenderer: Renders data in a format suitable for Django admin interface.
Answered by AI
Add your answer
Q3. What is Method Resolution Order?
Ans. 
Method Resolution Order (MRO) is the order in which classes are searched for a method or attribute in Python.
• MRO is determined by the C3 linearization algorithm in Python.

• It follows a depth-first left-to-right traversal of the class hierarchy.

• MRO is important in multiple inheritance scenarios to resolve method conflicts.

• Example: class A: pass class B(A): pass class C(A): pass class D(B, C)
Answered by AI
Add your answer
Q4. Difference between class method and static method.
Ans. 
Class method is bound to the class itself, while static method is not bound to any specific instance or class.
• Class method takes 'cls' as the first parameter, allowing access to class variables and methods.

• Static method does not take any special parameters and does not have access to class or instance variables.

• Class method can be called on both the class and instances of the class.

• Static method is mainly used for util...read more
Answered by AI
Add your answer
Q5. What are transactions in SQL?
Ans. 
Transactions in SQL are a way to ensure data integrity by grouping multiple SQL statements into a single unit of work.
• Transactions help maintain the ACID properties (Atomicity, Consistency, Isolation, Durability) of a database.

• They allow multiple SQL statements to be executed as a single unit, either all succeeding or all failing.

• Transactions can be started with BEGIN TRANSACTION, COMMIT to save changes, or ROLLBACK to...read more
Answered by AI
Add your answer

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

Verbal
reasoning
Coding
Technical

Python
Coding
Test

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. Decorators and its type in python
Ans. 
Decorators in Python are functions that modify the behavior of other functions or methods.
• Decorators are used to add functionality to existing functions without modifying their code.

• Types of decorators in Python include function decorators, class decorators, and method decorators.

• Example: @staticmethod and @classmethod are built-in decorators in Python.
Answered by AI
Add your answer
Q2. Oops concept abstraction , method overloading and overriding
Add your answer