Physicswallah Business Data Analyst Interview Questions and Answers

3 to 4 SQL queries based upon tables

Q1. More of behavioural check
Add your answer
Q2. How will you work under pressure
Add your answer
Q3. How will you optimize queries
Ans. 
Optimizing queries involves using indexes, limiting the number of columns retrieved, avoiding unnecessary joins, and using appropriate data types.
• Use indexes on columns frequently used in WHERE clauses

• Limit the number of columns retrieved to only those needed

• Avoid unnecessary joins by denormalizing data when possible

• Use appropriate data types to minimize storage and improve query performance
Answered by AI
Add your answer

Q1. More of behavioural questions
Add your answer