How I would deal with a report of slow database performance.
Junior Database Developer Interview Questions
4,136 junior database developer interview questions shared by candidates
What steps would you take when a performance problem is discovered?
Can you answer this in chinese?
What do you do outside your work?
Have you ever used "x" software.
If I won a million dollars, what would I do? Various behavioral questions, "if someone came to you and asked you to do something you knew would negatively impact something else, what would you do?" etc.
How do you setup a maintenance plan?
All questions were related to database like differences between function and procedures, Dense_rank and rank function, delete the duplicates, union and union all, why truncate is faster then delete etc
1. Design a scenario and normalize. (Realize anomalies and redundancies) 2. SQL queries (Aggregation, rank, etc.) 3. Database knowledge (Keys, Indexes, all questions included a "when do you do it or not do it")
First question was to design a schema. second was to write few queries for the given data. Third question was to write an algorithm to print the number of prime numbers between a given range
Viewing 3171 - 3180 interview questions