📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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
      More IT Networking Questions
      ask-question