SGS Engineer Trainee Interview Questions and Answers

Q1. Strenths and weekness
Add your answer
Q2. Why should we hire you
Add your answer

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. Tell me about yourself? would like to relocate if needed?
Add your answer

Q1. Telephone SQL questions regarding joins,index, views etc.
Add your answer

Q1. Face to face sql questions like joins, questions from two tables after joining, identity etc.
Add your answer

Q1. Mammalian Cell Culture
Add your answer
Q2. Elisa- principle, detection, types,
Add your answer

Q1. Maintenance of equipment
Add your answer
Q2. Operations
Add your answer

Q1. About your knowledge and your past experiences.
Add your answer

Transformation of the car t cell using DNA method

Q1. Where do i live in mumbai and maharashtra
Add your answer
Q2. What is my minimum expected salary CTC from the company
Add your answer

Q1. What is pv and whats its use
Ans. 
PV stands for Present Value and is used in finance to calculate the current value of a future sum of money.
• PV is used to determine how much a future sum of money is worth in today's dollars.

• It is commonly used in financial analysis, investment decisions, and loan calculations.

• The formula for PV is: PV = FV / (1 + r)^n, where FV is the future value, r is the discount rate, and n is the number of periods.

• For example, if ...read more
Answered by AI
Add your answer