Terrace Consulting interview questions

1 HR Interview Normal questions behavioural in type 1)What motivates you 2)Did you work in a group before 3)Past projects 4)Conflicts wiht teammates 5)How do you handle pressure 6)Where do you see yourself 5 years down 2)Technical Phone Screen with director of SW Engineering Lasted 30 mins 1)Questions about my projects 2)Expalin in complete detail one of your projects 3)Given a table Employee with Employee Id ,Employee Name,Manager Id (Manger Id just references another entry in the employee)write a query to print all employeenames ,their manager names and employee Id 4)Given a table Customers with customer Id and Orders with customer Id ,order no ,order details,print all customers who have placed no orders. 5)Difference betwwen OOD and a scripting language 6)OOP and OOD of a chess game. 7)Given a string find the first non repeating character in it. 8)Explain in detail what happens when you enter in a URL in your browser 9)Differecnce between Abstract and Interface