Question 2 DBMS Placements and SQL Practice

For Complete YouTube Video: Click Here

We will try to solve Question 2 DBMS Placements and SQL Practice, in this class.

The Database Management Systems DBMS is the prerequisite course to understand the concepts we discuss.

These kinds of questions are frequently asked in the campus placement’s written tests. All these questions are asked in service-based companies like Wipro, Infosys, CTS, TCS, Accenture, IBM, and many more service-based companies.

Question 2 DBMS Placements and SQL Practice

Table: Employee1

empidempnameunit
E101JohnIVS
E102JackICP
E103JaneIVS
E104EdwardIMS
Table 1

Table Projectallocation

pidempidlocation
P101E102Bangalore
P102E104Mexico
P103E102Bangalore
P104E104Bangalore
Table 2

Query:

SELECT e.empid, e.empname, location FROM employee1 e LEFT OUTER JOIN projectallocation pa ON e.empid = pa.empid AND pa.location = ‘Bangalore’;

How many rows will be fetched when the above query is executed?

  1. 5  
  2. 6
  3. 7
  4. 8

A detailed explanation of the above question is made in the above youtube link.