Atrina Technologies Python Software Developer Interview Questions and Answers

Q1. : Tell me about yourself
Add your answer
Q2. What is the difference between hard work and smart work? Tell me about the most boring job you have ever had?
Add your answer

Q1. What is http? rest api?
Ans. 
HTTP is a protocol used for transferring data over the internet. REST API is a set of rules for building web services.
• HTTP stands for Hypertext Transfer Protocol, used for communication between web servers and clients

• REST API (Representational State Transfer) is a set of rules for building web services that adhere to the principles of REST

• RESTful APIs use standard HTTP methods like GET, POST, PUT, DELETE to perform CRU...read more
Answered by AI
Add your answer
Q2. What is time complexity?
Ans. 
Time complexity refers to the amount of time an algorithm takes to run as a function of the input size.
• It measures how the runtime of an algorithm grows as the input size increases.

• Common time complexities include O(1) constant time, O(log n) logarithmic time, O(n) linear time, O(n^2) quadratic time, and O(2^n) exponential time.

• Understanding time complexity helps in analyzing and optimizing algorithms for efficiency.

• Ex...read more
Answered by AI
Add your answer

Q1. Self introduction
Add your answer

Basic python coding data type related coding

30mins on diff python and flask

Q1. Data structures
Add your answer
Q2. Object orientation
Add your answer

Round 1- 20 Ques (Foundation)
Round 2- 15 Ques (Advanced-contains both Quants and Logical

3-4 questions are asked

Q1. What are interrupts?
Ans. 
Interrupts are signals sent to the CPU to temporarily suspend the current program and handle a specific event or request.
• Interrupts allow the CPU to respond to events in real-time without wasting processing power.

• They can be generated by hardware devices, software programs, or the CPU itself.

• Examples include keyboard input, timer expiration, and hardware errors.
Answered by AI
Add your answer
Q2. What do you mean by SQL Correlated Subqueries?
Ans. 
SQL correlated subqueries are subqueries that reference columns from the outer query.
• Correlated subqueries are executed for each row processed by the outer query.

• They are used to filter results based on values from the outer query.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM table2 WHERE table2.id = table1.id)
Answered by AI
Add your answer

Q1. What is a one-line function?
Ans. 
A one-line function is a function written in a single line of code, typically used for simple operations.
• One-line functions are concise and easy to read, often used for simple tasks like mathematical operations or string manipulation.

• They are commonly used in lambda functions in Python.

• Example: lambda x: x**2
Answered by AI
Add your answer
Q2. What is polymorphism in OOps?
Ans. 
Polymorphism in OOPs refers to the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to represent different data types.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: In Python, the '+' operator can be us...read more
Answered by AI
Add your answer
Q3. Remove duplicates from the table.
Ans. 
Use SQL query with DISTINCT keyword to remove duplicates from the table.
• Use SELECT DISTINCT column_name FROM table_name to retrieve unique values from a specific column.

• Use DELETE FROM table_name WHERE column_name IN (SELECT column_name FROM table_name GROUP BY column_name HAVING COUNT(*) > 1) to remove duplicates from the table.
Answered by AI
Add your answer
Q4. Join two tables?
Ans. 
Use SQL JOIN to combine rows from two tables based on a related column between them.
• Use JOIN keyword in SQL to combine rows from two tables based on a related column

• Types of JOINs include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. Ask python programming language and coding as well as some some extra directories.
Add your answer
Q2. What is mean by monkey patching?
Ans. 
Monkey patching is a technique in Python where existing code or modules are modified at runtime.
• Monkey patching involves dynamically changing or extending the behavior of a module or class at runtime.

• It can be used to fix bugs, add new functionality, or temporarily change the behavior of existing code.

• Monkey patching can be a powerful tool but should be used carefully to avoid unexpected side effects.

• Example: Adding a ...read more
Answered by AI
Add your answer