TCS iON Python Software Developer Interview Questions and Answers

They will test your coding ability on first round, for me they kept test on hacker earth.

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

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. Simple logical question like sorting and some list based question
Add your answer

Prepare coding with some therotical question