I applied online. I interviewed at First Line Software (Saint Petersburg, Sankt-Peterburg) in Dec 2018
Interview
With HR interview was quite professional, she told me a lot of information about the job, I had almost no non-technical questions after that. Although she forced me to tell her my wanted salary number first. A small English talk was also tested.
Tech interviewers arrived and immediately started asking SQL questions, without ever asking a bit about me and my experiences, that was quite unusual. Many of the questions were not very hard or required deep knowledge, but they touched some details of the SQL, which are not on the surface. Also there was no "make a query" question planned by them, mainly theoretical or small-case scenarios qustions.
Interview questions [5]
Question 1
Whats the difference between CHAR and VARCHAR (VARCHAR and VARCHAR2 as well).
There are 5 fields in the column "c" of table "table", and one of that 5 fields contains NULL in it. What number will COUNT(*) from table return? How many would be from COUNT(c) from table?