Sql Database Developer sollicitatievragen
42
Sollicitatievragen voor Sql Database Developer gedeeld door sollicitantenMeest gestelde sollicitatievragen
Tell me something about yourself and your work
1 antwoorden↳
You say what you've done so far and they hear as if not interested and then ask same things again and again, this is what Head of HR - Suresh in Pune did and even after telling in 1st round clearly that being a girl I won't do night shift the asked me to wait for further rounds and the slow process made it from morning to evening with no lunch time provided to end up 2nd round and HR round only to come back with no offer as HR forced me for Night shift Minder
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??
1 antwoorden↳
Without being able to restructure the existing schema your only choice is to de-normalize the data. When the data gets loaded on that weekly schedule, also build a flat table so there are no relationships being built. Minder
Please try to be as detailed as possible regarding the technical question, business case, etc.
1 antwoorden↳
CTE vs. Temp Table vs. Variable Table
What is the ascii code for line feed?
1 antwoorden↳
CHR(10) is the answer but this is such a waste of time to ask. This doesn't indicate that you can code or can think through tough assignments to come up with a reasonable solution. Minder
Do you have any questions for me?
1 antwoorden↳
I hate this question - they usually drone on and on about themselves that all I want to do is make like a tree and leave! Minder
The Offer I kick myself now for not using glass door to find out abut this company first.
1 antwoorden↳
I got the offer before I even made it home from the interview. 35min drive for me to the location. I kick myself now for not using glass door to find out abut this company first. Minder
Please try to be as detailed as possible regarding the technical question, business case, etc.
1 antwoorden↳
CLASIC ONE: Type of indexes. Clustered vs. non-clustered... if you can add the COLUMNSTORE INDEX...it will not be applicable for this job but will show that you at least know about it Minder
Standard interview and technical questions.
1 antwoorden↳
Well I kick myself now for not using glass door to find out abut this company first. Minder
what's the database instance?
1 antwoorden↳
A db instance is an install of a database server. A db instance can contain many databases. Therefore, identifying the instance isn't enough when connecting remotely - you also need to tell the instance which of its databases you want to connect to. Minder