Oasis TechnoSoft Senior Software Engineer Interview Questions and Answers

Q1. Java questions and basics of testing
Add your answer

Q1. What are decorators in Python What is the use of __name == __main__ Django related questions
Ans. 
Decorators in Python are functions that modify the behavior of other functions or methods. __name__ == __main__ is used to check if a Python script is being run directly or imported as a module.
• Decorators are used to add functionality to existing functions without modifying their code.

• They are defined using the @decorator syntax before the function definition.

• Example: @staticmethod decorator in Python is used to define...read more
Answered by AI
Add your answer

Q1. Joins in SQL, Window functions Coding question Django ORM questions
Add your answer

Q1. Salary related questions
Add your answer

Q1. Basic java and rest full API, multithreading and stream
Add your answer

10 min aptitude test

3 coding problem to solve on hackerrank

Multiple choice test

Q1. Technical interview
Add your answer

Q1. HR discussion and salary negotiations
Add your answer

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Q1. Basic ios Questions No DS questions
Add your answer
Q2. Basic swift quesions
Add your answer
Q3. In App Purchase
Add your answer
Q4. Hardware Device connectivity
Add your answer