Database Developer Question:
Download Questions PDF

Tell me why DBAs don’t like cursors?

Answer:

I like to phrase this interview question this way because I’m not saying the DBA is right – I’m just asking the developer to explain the DBA’s point of view. I don’t have a problem with the developer rolling their eyes as they explain the answer, but I have a problem with the developer being surprised by the question.

The candidate gets bonus points if they seem even vaguely aware of the terms “set-based processing” and “row-based processing”, but that’s purely a bonus. (I wish I could say that these concepts are requirements, but in today’s economic market, companies don’t always want to pay top dollar to get the best candidates.)

Download Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Explain me what is the difference between Union and Union All command?Tell us what are the different types of SQL commands?