SIPL Python Developer Intern Interview Questions and Answers

3 Questions of competitive programming any language of your choice and 2 MySQL queries. Total test time 2 hrs

Q1. Gave a problem for SQL query
Add your answer
Q2. Gave a problem for python. She preferred Java more.
Add your answer
Q3. Asked about projects
Add your answer

Q1. Flexible at any shift? Flexible at any location?
Add your answer

All went good asked mostly regarding age and english sentances

Q1. Tell me about yourself
Add your answer
Q2. Project architecture
Add your answer
Q3. Sns vs SQS architecture
Ans. 
SNS is a pub/sub messaging service while SQS is a message queue service in AWS architecture.
• SNS allows for push notifications to multiple subscribers, while SQS is used for decoupling services and handling asynchronous tasks.

• SNS is used for real-time messaging and event-driven architecture, while SQS is used for reliable message processing and scaling.

• SNS supports multiple message delivery protocols like HTTP, HTTPS, E...read more
Answered by AI
Add your answer
Q4. S3 file parking and triggers
Add your answer
Q5. Explain Eventbridge
Ans. 
Eventbridge is a serverless event bus service provided by AWS for connecting applications using events.
• Eventbridge allows different AWS services, SaaS applications, and custom applications to communicate with each other through events.

• It simplifies the process of building event-driven architectures by decoupling producers and consumers of events.

• Eventbridge can be used to trigger automated workflows, connect different ...read more
Answered by AI
Add your answer

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. Basic python questions
Add your answer
Q2. SQL join query and update query
Add your answer

Q1. Salary expectations
Add your answer
Q2. Other basic questions
Add your answer

Q1. Valid Sudoku leetcode problem
Add your answer
Q2. Generate Parentheses leetcode problem
Ans. 
Generate all valid combinations of parentheses for given n pairs
• Use backtracking to generate all valid combinations of parentheses

• Keep track of the number of open and close parentheses used

• Add open parenthesis if there are remaining open parentheses, add close parenthesis if there are more open than close parentheses
Answered by AI
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. Python project overview
Ans. 
Python project overview
• Describe the purpose and goals of the project

• Explain the technologies and tools used in the project

• Discuss the project's architecture and design

• Highlight any challenges faced and how they were overcome
Answered by AI
Add your answer
Q2. CI/CD related with AWS
Add your answer