How would you deal with a developer who writes bad code?
Senior Database Developer Interview Questions
88 senior database developer interview questions shared by candidates
What makes you feel you Are different from many programmers out
The HR questions were standard questions about my overall experience. I talked with several members of the development team. There were not really any specific technical questions, but mostly overall descriptions of what the job would entail. The hiring manager did ask a few technical questions but they were fairly simple. The hiring process has since changed, at least in the group I was in. The process is much more strict and the interviews are much more technical.
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
Why do you want to work for JP Morgan Chase.
Details of my day to day work
what is your goal in 5 years
In a SELECT statement over multiple tables, does moving WHERE conditions into the JOIN clause make the SELECT statement faster?
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
Plsql performane tuning techs
Viewing 1 - 10 interview questions