Olive Healthcare Interview Questions and Answers

There were two question on DSA

Q1. Basic questions like do you know Power BI
Add your answer
Q2. Do you know DAX
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and other Microsoft tools for data modeling and analysis.
• DAX is used to create calculated columns and measures in Power BI.

• Example: A measure to calculate total sales could be written as: Total Sales = SUM(Sales[Amount]).

• DAX functions include SUM, AVERAGE, COUNTROWS, and more for data aggregation.

• It supports time intelligence functions like ...read more
Answered by AI
Add your answer

Q1. What is Pharmacokinetic?
Add your answer
Q2. How to derive sample size?
Ans. 
Sample size determination is crucial for statistical validity in research, ensuring accurate and reliable results.
• Identify the population: Define the group you want to study, e.g., all adults in a city.

• Determine the margin of error: Decide how much error is acceptable, e.g., ±5%.

• Select a confidence level: Common levels are 90%, 95%, or 99%, indicating how sure you want to be about your results.

• Estimate the population v...read more
Answered by AI
Add your answer

Q1. Explain Behaviour subject in Angular.
Ans. 
Behaviour subject in Angular is a special type of subject that allows both subscribing and emitting values.
• BehaviourSubject is a type of subject in RxJS library.

• It has an initial value that will be emitted to new subscribers.

• It stores the latest value and emits it immediately to new subscribers.

• Example: const subject = new BehaviorSubject('initial value');

• Example: subject.next('new value');
Answered by AI
Add your answer
Q2. Explain Design Principles
Ans. 
Design principles are guidelines for designing software solutions that are maintainable, scalable, and efficient.
• Design principles help in creating software that is easy to understand, modify, and maintain.

• They promote code reusability, modularity, and flexibility.

• Examples of design principles include SOLID principles, DRY (Don't Repeat Yourself), KISS (Keep It Simple, Stupid), and YAGNI (You Aren't Gonna Need It).
Answered by AI
Add your answer

Q1. Anagram of two strings in java
Add your answer
Q2. Insert and select query in MySQL
Ans. 
Insert and select data in MySQL using SQL queries
• Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data

• Use SELECT * FROM table_name; to select all data from a table

• Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
Answered by AI
Add your answer
Q3. Get and Post APIs in rest
Ans. 
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
• GET method is used to retrieve data from a server

• POST method is used to send data to a server

• GET requests are idempotent, while POST requests are not

• GET requests should only be used for retrieving data, not for modifying data

• Example: GET request to retrieve a list of users - GET /users

• Example: POST request to create a new user - POST /users
Answered by AI
Add your answer

Q1. What is Real World Evidence?
Add your answer
Q2. How to get frequency counts?
Ans. 
Frequency counts can be obtained by counting the number of occurrences of each unique value in a dataset.
• Use the COUNTIF function in Excel to count occurrences of a specific value in a column

• Use the value_counts() function in Python's pandas library to get frequency counts of unique values in a dataframe column

• Use the table() function in R to get frequency counts of unique values in a vector or dataframe column
Answered by AI
Add your answer

Q1. General information
Add your answer

Q1. ECTD, EU Procedures
Add your answer

Q1. Salary Negotiation
Add your answer