Apitoria Pharma DPT.Manager Interview Questions and Answers

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. 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. Current profile in brief
Add your answer
Q2. Goal of future and improvement
Ans. 
My goal is to continuously improve my skills and knowledge to become a successful Deputy Manager.
• Continuously seek opportunities for professional development and training

• Set specific goals for career advancement within the company

• Seek feedback from supervisors and colleagues to identify areas for improvement

• Stay updated on industry trends and best practices

• Lead by example and inspire team members to strive for excellen
Answered by AI
Add your answer

Assignments are shared for most of the roles and they are reviewed thoroughly

Q1. Knowledge and practical working test
Add your answer

Q1. To test the personality and behaviours
Add your answer