1. Introduce yourself 2. What are your strengths and weakness 3. Why do you choose this role 4. How do you justify this position if we hire you 5. How you can automate the file processing 6. Tell me couple of scenarios where you have used the triggers 7. Write the general syntax for procedure 8. How do you implement equi-width histograms 9. Usage of aggregate functions 10. CASE vs DECODE with examples
very through on resume and what exactly have you done in each of past experience. mix of both type of questions like deep db internals and over all big picture design. Over all enjoyed talking to every team member. Unfortunately may be it was mistake on my side that I might have miss understood over all compensation expectation hence I decline the offer but work/team over all very nice.
Plsql performane tuning techs
Specific questions on Data Migrations, Data Loads, Database tuning
What are disadvantages of partitioning?
How can you fit in this role and explain the scenario where you helped your company to reduce costs.
What do you understand about Hotfixes in the content of SQL Server Databases?
Basic Sql questions for join, optimisation and subquery.
Have you build custom Snowflake clusters?
Given a real time scenario and asked to write query.
Viewing 21 - 30 interview questions