Candidatei-me por meio de recrutador(a). O processo levou 5 dias. Fiz uma entrevista na empresa Ness Digital Engineering.
Entrevista
• Experience with database optimization? Which would make queries faster?
• What is an index?
• Different types of indexes and indexes strategies? Explain how to choose one
• Put an example of the use of key-reverse index
• What kind of improvement would you get with a correct indexing strategy?
• What is the cache in database?
• When is necessary to apply the cache?
• Highlight one situation where is not recommended to use the cache
• What kind of improvement will you get if you use cache in queries? Aprox 218%
• What decrease will you get if you use cache wrongly? Aprox 13%
• Slow queries, how would you detect one? Which tool will you use?
Perguntas de entrevista [1]
Pergunta 1
• Would you recommend Hibernate in a system with high number of user accessing to the same information? (Concurrency) why yes or not?
• How is the cache in Hibernate? How many levels has it got?
• Cache in hibernate, could it be activated/deactivated? How?
• Have you got any exposure to iBatis? In case yes, when would you use it? (Examples)
• What is the main difference between changing a query in Hibernate and in iBatis? (if experienced in both)
• Changeable database environment. What would you use? iBatis or Hibernate?
• Any exposure to JPA? When would you recommend to use it?
• Hibernate vs iBatis iBatis vs JPA Hibernate vs JPA
