The hiring manager asked me some questions about relational vs. Star Schema. He also asked me to review some code and comment on it. I brought code samples with me and talked him though what I’d done and I think that really helped. The users mostly asked me what type of work I did and some general SQL questions, nothing too hard.
SQL Query to fetch 2nd highest salary
Tell me about your project?
Tell me about yourself. Why do you want to change? What do you know about Yardi software? In written tests they would test group by, order by stuffs. Then joins. Analytic functions based queries.
About project
write a query to delete duplicate row from table
Why do you want to join this company
Do you have any questions for me?
Tell me about your self with educational qualifications and work experience. What's your plans in next 3-4yrs.? 5 data types in c programming. Difference between stack and queue. Difference between where and having clauses. Types of joins.
Are you open for learning new technologies.
Viewing 221 - 230 interview questions