MidasCare Pharmaceuticals Executive Regulatory Affairs Interview Questions and Answers

Q1. Why should we hire you?
Add your answer
Q2. What does your previous colleagues describe you?
Add your answer
Q3. Self introduction
Add your answer
Q4. General questions from resume
Add your answer

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. What is the notice period?
Ans. 
The notice period is the amount of time an employee is required to give to their employer before resigning or terminating their employment.
• The notice period is typically stated in the employment contract or company policy.

• It is a formal way for employees to inform their employer about their intention to leave the job.

• The duration of the notice period can vary depending on the company and the employee's position.

• During ...read more
Answered by AI
View 1 more answer
Q2. Tell me about 21cfr part11
Add your answer

Q1. Process of aggregate in brief for all sections
Ans. 
Aggregate is the process of combining data from different sections into a single result.
• Aggregate functions are used to perform calculations on groups of rows to give a single result.

• Common aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• Aggregate queries often involve grouping data by certain criteria before applying the aggregate function.

• For example, calculating the total sales revenue by region or finding
Answered by AI
Add your answer