Preguntas de entrevistas para Desarrollador De Sql Server
166
Preguntas de entrevista para el cargo de Desarrollador De Sql Server compartidas por los candidatosPreguntas de entrevista principales
If I knew what the cross apply operator was
4 respuestas↳
If they want the word its join, a description could be "the Cartesian product of multiplying the tables" and an example would be "like merging two matrices except every column may be of incongruent variables creating a result with polynomial rows, (which is likely no longer normalized to the form level of the database)" Menos
↳
An Apply operator is a join type that the query engine evaluates in sequential order because the right-hand table object can reference data in the left-hand table object. The Cross Apply operator is the Apply operator that acts like an Inner Join, eliminating any records in the left-hand table object that have a null match in the right-hand table object. Menos
↳
An Apply operator is a join type that the DB engine evaluates in sequential order because the right-hand table object can reference data in the left-hand table object. The Cross Apply operator is the Apply operator that acts like an Inner Join, eliminating any records in the left-hand table object that have a null match in the right-hand table object. Menos
Come up a most efficient way to determine if a integer is odd or even.
2 respuestas↳
int number = ...; if(number % 2) { odd } else { even }
↳
Compilers are smart enough to understand the result of n%2. Don't over-complicate it. Menos
Nothing much really but one individual ask more nuts and bold questions. What is the size of big int or 10 min to build tree structure
2 respuestas↳
8 bytes
↳
Difference between Stored procedures and functions?
Describe my experience with ETL and Accounting Procedures.
1 respuestas↳
I mentioned some accounting systems that I designed, coded and implemented. Also I spoke at length about a project where I wrote and administered a large ETL project that I headed. We added clients and modified our process to accommodate client and supplier requirements. And we moved a lot of data each night. Menos
How would you implement a T9 words index? (like the one found in celluar phones) Describe the data structure/s and search algorithm while the user types the letters.
1 respuestas↳
In general: a tree where each path from the root to a terminating 'symbol' in the tree is a word. You should define what each tree node contains and how do you decide that a path is a word. Menos
Nothing unexpected or difficult. Given a sum and an array, print out pair of elements that contribute to that sum.
1 respuestas↳
You can use python dictionary to solve this problem.
Do you have any personal projects or games you've made?
1 respuestas↳
No, I don't. But when I was college student, I made a simple game.
SQL server questions, write queries, know about health insurance process, ?
1 respuestas↳
Answered questions
There are lot of questions about different topics including decoupled and micro services architectures, scaling out applications, share nothing architecture and general computer science topics and specific Python language questions. Then there is a coding test where you are asked to implement a small and simple game server with an in-memory database backed that must supports some interesting features from the scalability point of view mainly.
1 respuestas↳
Answer every question honestly, if I didn't know about some topic I just said so and then guessed or speculated with the interviewer about a possible answer. I also implemented the simple game server with almost all the specified features. Menos