Syngene International Maintenance Engineer 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

English, quants, reasoning

Q1. Logical based questions for the problem in any language
Ans. 
Logical questions assess problem-solving skills and analytical thinking in various scenarios.
• Identify the problem clearly before attempting to solve it.

• Break down the problem into smaller, manageable parts.

• Use examples to illustrate your thought process, like solving a math equation step-by-step.

• Consider edge cases and alternative solutions to ensure robustness.
Answered by AI
Add your answer

Q1. About your experience
Add your answer

Q1. Will be full on previous experience technical found
Add your answer
Q2. Previous company technical questions
Add your answer

Q1. Why chose dry lab over wet lab?
Add your answer
Q2. How to deal with various challenges in Work Life?
Ans. 
Navigating work-life challenges involves effective communication, time management, adaptability, and maintaining a positive mindset.
• Effective Communication: Open dialogue with colleagues can resolve misunderstandings. For example, scheduling regular check-ins can clarify project goals.

• Time Management: Prioritizing tasks using tools like the Eisenhower Matrix helps in focusing on what’s urgent and important, reducing st...read more
Answered by AI
Add your answer

Q1. Do you have any experience working with any EDC or CDMS software? If yes, please elaborate.
Add your answer
Q2. Expand and elaborate on the ALCOA-CCEA principles.
Add your answer
Q3. What is your understanding of CROs and CDM?
Add your answer
Q4. Name all the entities involved in a clinical trial and explain their roles.
Add your answer
Q5. What are some things you know about ICON and why are you interested in working for this company?
Add your answer
Q6. How would handle a certain situation? E.g. You have a fast-approaching deadline and are facing delays in the submission/communication of deliverables.
Ans. 
To handle deadline delays, prioritize tasks, communicate proactively, and seek support to ensure timely deliverables.
• Assess the Situation: Quickly evaluate the reasons for the delay and identify the most critical tasks that need immediate attention.

• Prioritize Tasks: Use a priority matrix to determine which deliverables are essential and focus on completing those first.

• Communicate Early: Inform stakeholders about the de...read more
Answered by AI
Add your answer