Zifo RnD Solutions Graduate 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, Quantitative Ability, Data Interpretation

Multiple guesstimates, questions on resume and work experience

Q1. About Validations and batch analysis
Add your answer
Q2. Knowing all those technical things express
Add your answer
Q3. Salery package asks hr
Add your answer

Q1. Technical questions technical questions
Add your answer
Q2. About hplc GCMS icp oes
Add your answer

Q1. Chemistry related, Formulas of glucose, urea etc
Add your answer
Q2. Amino acids related, biochemistry topics, basic structure of sulphonamide
Add your answer

Q1. Electrical Mechanical HVAC GMP Documentation Safety Process Equipment
Add your answer