Alchem International R&D Chemist Interview Questions and Answers for Freshers

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. Why we should hire you?
Add your answer

Q1. What do you mean by sla
Ans. 
SLA stands for Service Level Agreement, a contract between a service provider and a customer that defines the level of service expected.
• SLA is a formal agreement between a service provider and a customer outlining the services to be provided, the responsibilities of each party, and the expected level of service.

• It typically includes details such as uptime guarantees, response times, and penalties for not meeting the ag...read more
Answered by AI
Add your answer
Q2. What is ec2 in aws
Ans. 
EC2 in AWS stands for Elastic Compute Cloud, a web service that provides resizable compute capacity in the cloud.
• EC2 allows users to rent virtual servers on which they can run their own applications.

• Users can choose the instance type, operating system, and storage options for their EC2 instances.

• EC2 instances can be easily scaled up or down based on demand, providing flexibility and cost efficiency.

• Examples of EC2 inst
Answered by AI
Add your answer

It was easy normal data regarding test

Q1. Process related
Add your answer

Q1. Job responsibility
Add your answer

Q1. Process related question and Regulatory related
Add your answer