Name one thing you accomplished last year you were proud of.
Database Programmer Interview Questions
785 database programmer interview questions shared by candidates
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??
Asked me to write complex queries on white board
He started with sharing a simple structure definition and asked how to determine if the contents of the structure could be identified as a B-Tree data structure. He did not work with group I was applying to - no local people to meet with.
How do you know if data exists in one table and not in another.
How do you know if data exists in one table and not in another.
They asked about my current skillset and experience so they can find the right job.
give an database to select some information using SQL, Java, PL/SQL, reverse a string, Design cycle, override
What time would you like to work?
See my description of the interview process. The question was basically, "Will you debase yourself enough to jump through our hoops, to have the privilege of a hiring manager actually seeing your resume."
Viewing 41 - 50 interview questions