Pergunta de entrevista da empresa HCLTech
Write a SQL statement that gets [3 things] from _______ table and this information, sort it by date and group by such and such. What are joins? Explain the various joins and how they work. What statement would you use to clear all the data in a table? Question about having 3 containers of water and how to measure out 10 gallons from what you have. Story problems like "This person is selling oranges. She sold 1/2 an orange more than half of what she had, then sold 1/3 of an orange from what she had left. Also, she didn't cut any oranges. How many oranges did she have to start with?" Pretty ridiculous.
Resposta da entrevista
Sigiloso
If you want to apply to work at this place (why?) I recommend you take some practice aptitude tests online and brush up on SQL statements. Also, call the organization before you go to make sure that you're actually testing for the position that you think you are, because they have some miscommunications going on. Don't spend too much time on one question; one guy told me he spent way too much time on the water containers question, which would have been better spent on answering some questions correctly, that he did know the answer to.