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.
Table of Contents
Question 2 DBMS Placements and SQL Practice
Table: Employee1
empid | empname | unit |
E101 | John | IVS |
E102 | Jack | ICP |
E103 | Jane | IVS |
E104 | Edward | IMS |
Table Projectallocation
pid | empid | location |
P101 | E102 | Bangalore |
P102 | E104 | Mexico |
P103 | E102 | Bangalore |
P104 | E104 | Bangalore |
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?
- 5
- 6
- 7
- 8
A detailed explanation of the above question is made in the above youtube link.