SQL Interview Question

Type Of JOINS
INNER JOIN-simple join/default
    Returns all rows for which there is at least one match in both table

LEFT JOIN- left outer join
    Return all rows form left table and the match row form right table

RIGIT JOIN-right outer join
    Return all from right table and match row for left table

FULL JOIN
    Return all rows for which there is a match in either of tables. union of left and right join

CROSS JOIN

   

Interview Question

IOC vs ID?
IOC
Giving control to the container to get instance of object is called Inversion of Control., means instead of you are creating object using new operator, let the container do that for you.

DI
Way of injecting properties to an object is called Dependency injection.
    We have three types of Dependency injection
        1)  Constructor Injection
        2)  Setter/Getter Injection
        3)  Interface Injection - not support by spring