New Click here to Enroll for SIDBI MSME Expert Classes by Experts

    Register

    Question

    SELECT E.EmpFname, E.EmpLname, P.EmpPosition FROM

    EmployeeInfo E INNER JOIN EmployeePosition P ON E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager'); This query will give
    A fetch all employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
    B fetch all employees who also does not hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
    C fetch all employees who also hold the managerial position from outer join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
    D fetch Top employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePosition Correct Answer Incorrect Answer
    E None Correct Answer Incorrect Answer

    Solution

    The correct answer is A

    Practice Next