OpenDr PHP Developer Interview Questions and Answers

Q1. Wht is tuple and how it is dif from list
Ans. 
A tuple is an immutable collection of elements, while a list is a mutable collection in Python.
• Tuples are created using parentheses (), while lists are created using square brackets []

• Tuples are immutable, meaning their elements cannot be changed once defined

• Lists are mutable, allowing for elements to be added, removed, or modified

• Tuples are typically used for fixed collections of items, while lists are used for dynami
Answered by AI
Add your answer

Q1. Coin change problem
Add your answer

Q1. .net related questions
Add your answer

Q1. Functional knowledge
Add your answer

Q1. Discussion of salary and position
Add your answer

Q1. Tell about a time where you had competing demands from stakeholders.
Add your answer

Q1. What's your weakest points?
Ans. 
My weakest point is sometimes struggling with time management and prioritizing tasks effectively.
• Occasionally have difficulty balancing multiple projects at once

• May need to improve on setting realistic deadlines and sticking to them

• Working on improving communication with team members to ensure tasks are completed on time
Answered by AI
Add your answer

3 questions of medium to hard coding questions.

Q1. Technical interview including SQL, one programming language, and dbms based questions. the interview went well and was of 90mins.
Add your answer

There are 30 questions Mixed with Aptitude, AWS, OS

Q1. 1. what is OOPS Concept?
Ans. 
OOPS (Object-Oriented Programming) is a programming paradigm that uses objects to represent and manipulate data.
• OOPS focuses on the concept of objects, which are instances of classes.

• It emphasizes encapsulation, inheritance, and polymorphism.

• Encapsulation ensures data hiding and abstraction.

• Inheritance allows classes to inherit properties and behaviors from other classes.

• Polymorphism enables objects to take on multiple...read more
Answered by AI
View 1 more answer
Q2. Database questions and data structure questions?
Add your answer

Q1. Basics of SQL, types of joins, cursors, triggers
Add your answer
Q2. Functions and Procedures and differences between them
Ans. 
Functions and procedures are both stored database objects used to perform specific tasks in SQL.
• Functions return a value while procedures do not.

• Functions can be used in SQL statements, whereas procedures cannot.

• Functions can have input parameters and return a single value, while procedures can have input and output parameters.

• Functions are typically used for calculations or data manipulation, while procedures are used...read more
Answered by AI
View 2 more answers
Q3. Performance tuning of SQL query
Ans. 
Performance tuning of SQL query
• Identify slow queries using profiling tools

• Optimize query structure and use indexes

• Reduce data retrieval by filtering and limiting results

• Avoid using subqueries and nested queries

• Use appropriate data types and avoid unnecessary conversions
Answered by AI
Add your answer

Q1. Similar questions to TR1, but this time with more depth and at advanced level
Add your answer
Q2. Given sample data on two tables, write down the result sets of all types joins.
Ans. 
The result sets of all types of joins in SQL
• Inner Join: Returns only the matching rows from both tables

• Left Join: Returns all the rows from the left table and the matching rows from the right table

• Right Join: Returns all the rows from the right table and the matching rows from the left table

• Full Outer Join: Returns all the rows from both tables, including the unmatched rows

• Cross Join: Returns the Cartesian product of b
Answered by AI
View 1 more answer
Q3. Write down a procedure to return a certain series (99, 96, 93, ...., 6, 3)
Ans. 
Procedure to return a series (99, 96, 93, ...., 6, 3)
• Create a temporary table with a single column

• Use a loop to insert values into the temporary table

• Return the values from the temporary table in descending order
Answered by AI
View 1 more answer
Q4. Extract execution plan of a SQL query
Ans. 
To extract execution plan of a SQL query, use EXPLAIN or SHOW PLAN command.
• Use EXPLAIN or SHOW PLAN command before the SQL query

• EXPLAIN command shows the execution plan in a tabular format

• SHOW PLAN command shows the execution plan in a graphical format

• Execution plan helps in optimizing the query for better performance
Answered by AI
Add your answer

Q1. Basic questions on project structure, development approach
Add your answer
Q2. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
Ans. 
A change request in an application is serviced by the development team through various stages such as business analysis, code analysis, discussion with BA, and requirement freeze.
• The development team starts by analyzing the change request to understand its impact on the application.

• They perform business analysis to determine the feasibility and potential risks of implementing the change.

• Code analysis is conducted to as...read more
Answered by AI
View 3 more answers

Q1. Casual meeting wrt expectations from project, work culture, etc.
Add your answer

Q1. CTC, location negotiation
Add your answer