associate software engineer interview questions shared by candidates
Whats the difference between inner join and outer join?
Inner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the Key
Specified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table.
Class, object, polymorphism, inheritance, encapsulation, interrupts, multi threading, try-throw-catch concepts, call by value, reference, pointers, semaphore, mutex, SRS, SDLC, stack, linkedlists, trees, OSI stack, TCP/IP, networking protocols. Go through job description and prepare accordingly.
You work in a factory that manufactures balls. One day one of the balls manufactured in a group of eight is slightly heavier than the rest. You have a standard scale with which you can weigh the balls. How would you go about finding the defective ball in the least amount of weighing attempts possible (maximum of 2 attempts).
- They say they are language agnostic but well... - Java shop! Know your Java and patterns in and out! - Basic basic data structure implementation - Mostly Java questions and Java design questions - No algorithms unlike other mainstream companies. - Little bit of database in the phone screen.
See Interview Questions for Similar Jobs
- Graphic Designer
- Pharmacy Technician
- Human Resource
- Sales Associate
- Administrative Assistant
- Pharmaceutical Sales
- Security Guard