BIOCHEM PHARMACEUTICALS Senior 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

Q1. MITER attack framwork/ Cyber kill chain process/attack vectors
Add your answer
Q2. SIEM tools and its use
Ans. 
SIEM tools are security information and event management tools used to collect, analyze, and report on security data.
• SIEM tools help organizations to detect and respond to security incidents in real-time.

• They collect data from various sources such as network devices, servers, and applications.

• SIEM tools use correlation rules to identify patterns and anomalies that may indicate a security threat.

• Examples of SIEM tools i...read more
Answered by AI
Add your answer
Q3. Are you written a playbooks rules
Ans. 
Yes, I have experience writing playbooks rules for automation in various engineering projects.
• Yes, I have written playbooks rules using tools like Ansible for automating infrastructure tasks.

• I have experience creating rule-based automation scripts to streamline engineering processes.

• I can provide examples of playbooks I have written for automating deployment, configuration, and monitoring tasks.
Answered by AI
Add your answer
Q4. Digital forensics working procedures
Ans. 
Digital forensics working procedures involve collecting, preserving, analyzing, and presenting digital evidence in a legally admissible manner.
• Collecting digital evidence from various sources such as computers, mobile devices, and cloud storage.

• Preserving the integrity of the evidence by creating forensic images and maintaining a chain of custody.

• Analyzing the evidence using specialized tools and techniques to uncover ...read more
Answered by AI
Add your answer

Q1. Memory management questions
Add your answer
Q2. Kernel questions
Add your answer

Q1. 1. project overview 2. difference between job, task and stage 3. difference between partition and colease 4. optimization techniques
Add your answer

Q1. Azure basics azure data factory
Add your answer

Q1. Network questions
Add your answer
Q2. Bgp routing protocol
Add your answer

Q1. Miter attack framework and incident response
Add your answer

Q1. How we find MHR
Add your answer
Q2. Different Manufacturing Process selection
Ans. 
Different manufacturing processes are selected based on factors like cost, quality, production volume, and material properties.
• Consider cost implications of each manufacturing process

• Evaluate quality requirements and capabilities of each process

• Take into account production volume and efficiency of each process

• Analyze material properties and compatibility with each process

• Examples: Injection molding for high volume plas...read more
Answered by AI
Add your answer

Coding based on string and arrays

Q1. Find a duplicate character in a string
Ans. 
Find a duplicate character in a string
• Iterate through the string and store each character in a hash set

• If a character is already in the hash set, it is a duplicate
Answered by AI
Add your answer

Q1. Java singleton class
Add your answer
Q2. Bean lifecycle
Add your answer

Q1. Multithreading implementation
Add your answer
Q2. Microservice architecture
Add your answer

Q1. Handling production
Add your answer
Q2. Work in timeline
Ans. 
Working in timeline involves planning, organizing, and executing tasks within specified timeframes.
• Create a detailed project timeline with milestones and deadlines

• Prioritize tasks based on urgency and importance

• Regularly review and adjust the timeline as needed

• Use tools like Gantt charts or project management software to track progress

• Communicate effectively with team members to ensure everyone is on track
Answered by AI
Add your answer