Syneos Health Supervisor Interview Questions and Answers

Q1. Basic topics of plsql
Add your answer
Q2. One query to fetch max n min of salary from emp table
Ans. 
Use SQL query to fetch maximum and minimum salary from emp table
• Use SELECT MAX(salary) FROM emp to fetch maximum salary

• Use SELECT MIN(salary) FROM emp to fetch minimum salary
Answered by AI
Add your answer

Q1. Performance tuning
Add your answer
Q2. Indexes and exceptions used
Ans. 
Indexes and exceptions are used to optimize database performance and handle errors in code.
• Indexes are used to quickly retrieve data from a database by creating a sorted list of values.

• Exceptions are used to handle errors in code and prevent the program from crashing.

• Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.
Answered by AI
Add your answer

About your company and warking culture

Q1. Salary discussion
Add your answer

Q1. Personal information Previous company job description What is GMP, deviation,CAPA, Change Control, Which type equipment handling, technical questions
Add your answer

Q1. Family Background Total experience Current CTC expected CTC
Add your answer

Q1. Regarding previous experience 1. Scale up & Scale down 2. Crystallization 3. Heat load Calculations 4. Trouble shoot 5. During Critical Reaction what kind safety precautions will use (like NBL, Thyniol Cl,...read more
Add your answer

Q1. Tyapes of distillation
Ans. 
Distillation is a process of separating components of a mixture based on their boiling points. There are several types of distillation.
• Simple distillation: used for separating components with large difference in boiling points

• Fractional distillation: used for separating components with closer boiling points

• Vacuum distillation: used for separating components with high boiling points

• Steam distillation: used for separatin...read more
Answered by AI
Add your answer
Q2. Which types of cleaning in pharma industries
Add your answer

Q1. Some questions related to technical
Add your answer

Q1. Discussion regarding salary package
Add your answer