Oasis Fertility Admin Executive Interview Questions and Answers

Q1. React hooks, Explain using code
Ans. 
React hooks are functions that let you use state and other React features without writing a class.
• Hooks are functions that let you use state and other React features in functional components

• useState() is a hook that allows you to add state to functional components

• useEffect() is a hook that allows you to perform side effects in functional components

• useContext() is a hook that allows you to use the context API in functio
Answered by AI
Add your answer
Q2. Factory Patterns?
Add your answer
Q3. Liskov Substitution Principle
Ans. 
Liskov Substitution Principle states that objects of a superclass should be replaceable with objects of its subclasses without affecting the program's correctness.
• Subtypes must be substitutable for their base types.

• Derived classes must be able to replace their base classes without affecting the program's behavior.

• Violating this principle can lead to unexpected behavior and errors in the code.

• Example: If a program expec...read more
Answered by AI
Add your answer
Q4. Oops Concept and give examples
Ans. 
Oops concept is a programming paradigm that focuses on objects and classes.
• Oops stands for Object-Oriented Programming

• Key concepts include inheritance, encapsulation, polymorphism, and abstraction

• Examples: Class Car with properties like make, model, and methods like start(), stop()

• Example: Inheritance - Class SUV extends Car and adds property numSeats
Answered by AI
Add your answer
Q5. JQuery - Ajax mechanisms
Add your answer
Q6. Docker and Kubernetes - Azure concepts
Add your answer

Q1. Previous Experience
Add your answer
Q2. Design Knowledge
Add your answer
Q3. Personally Based
Add your answer

Q1. Domain Knowledge Formal Testing
Add your answer
Q2. Lab Management Quality Assurance Design Assurance
Add your answer
Q3. Dv, TMV R&D Testing Mechanical
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. Tell Me Something About Yourself?
Add your answer
Q2. Last Job Experiences?
Add your answer

Q1. What is oops, what is abstraction
Ans. 
OOPs stands for Object-Oriented Programming. Abstraction is the concept of hiding complex implementation details and showing only necessary features of an object.
• OOPs is a programming paradigm that uses objects and classes to design and develop applications.

• Abstraction is the process of hiding the implementation details and showing only the necessary features of an object.

• For example, a car can be represented as an obj...read more
Answered by AI
Add your answer

Q1. What is the use of button when link can submit the form?
Ans. 
Buttons are used for actions within the form, while links are used for navigation.
• Buttons can trigger JavaScript functions or perform form validation before submission

• Buttons can have different styles and behaviors compared to links

• Buttons are more accessible for users with disabilities
Answered by AI
View 1 more answer

Q1. How do you optimize a SQL procedure with 5000 lines in code?
Ans. 
Optimize a SQL procedure with 5000 lines of code by identifying bottlenecks and implementing performance improvements.
• Identify and analyze the most time-consuming parts of the procedure

• Optimize queries by adding appropriate indexes, rewriting queries, or using query hints

• Break down the procedure into smaller, more manageable parts

• Use temporary tables or table variables to reduce the amount of data processed at once

• Cons...read more
Answered by AI
Add your answer
Q2. Keep SQL procedures short, use multiple small procedure with specific functionality being used, avoid use of temp tables and Joins, use select statements wisely. do not use sub queries, do not use dynamic ...read more
Ans. 
To optimize SQL procedures, keep them short, use small procedures with specific functionality, avoid temp tables and joins, use select statements wisely, avoid subqueries and dynamic SQL.
• Break down complex procedures into smaller ones with specific functionality

• Avoid using temporary tables and joins whenever possible

• Use select statements wisely to retrieve only the necessary data

• Avoid subqueries and find alternative ap...read more
Answered by AI
Add your answer

Aptitude related questions asked in form of mcq.

Coding questions are given

Q1. Asked about sql queries
Add your answer
Q2. Asked about oops concept
Add your answer

Q1. Asked about projects
Add your answer
Q2. Asked about goals
Add your answer