Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      Deskpro

      Is this your company?

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Deskpro reviews | Deskpro jobs | Deskpro salaries | Deskpro benefits
      Deskpro interviewsDeskpro Full Stack Developer interviewsDeskpro interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Indeed, Inc. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Indeed, Inc.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Full Stack Developer Interview

      7 May 2020
      Anonymous interview candidate
      London, England
      No offer
      Negative experience
      Easy interview

      Application

      I applied online. The process took 1 day. I interviewed at Deskpro (London, England) in Apr 2020

      Interview

      I interviewed with a robot online and they recorded my video. I answered the oldest programming question and their feedback was: "Thanks so much for taking the time to submit your video. Your passion for the subject was palpable! :-) However, some of your answers to the more technical questions weren't quite on point. For example, when reasoning about slow queries you talked a bit about the n+1 problem, a common problem to be sure, but you didn't offer solutions to the actual thing we asked about." and my answer was: "N+1 is a common problem in SQL. The solution for N+1 is (as I said) eager loading and lazy loading which meant Join table. Other than that over-indexing, under indexing or no clustered Index/primary key is other issues in SQL, it depends what is your definition of optimisation, is its speed, is it less query, is it execution time or is it memory usage. I don't think the question was clear nor any of your devs know this keeping in mind that the answers could be researched. Your feedback isn’t clear, the solution can be demonstrated in code, not a verbal explanation. I’m a developer and practical person. Remember one mechanic can talk and another mechanic can fix cars. which one your company prefers?" You are the judge.

      Interview questions [1]

      Question 1

      How do you optimise SQL queries?
      Answer question
      5