Syngene International Production Engineer Interview Questions and Answers

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

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.

Frequency counts can be obtained by counting the number of occurrences of each unique value in a dataset.

• Use the COUNTIF function in Excel to count occurrences of a specific value in a column

• Use the value_counts() function in Python's pandas library to get frequency counts of unique values in a dataframe column

• Use the table() function in R to get frequency counts of unique values in a vector or dataframe column