Select from following answers:- 50

- 15
- 500
- None of this
- All Above
Answer is 50, because 1st table is having 5 rows and 2nd table is having 10 rows and if we write
Select * from employee_master,project_master;
then this query will be treated as CROSS JOIN and will do the Cartesian product of these 2 tables will be (employee_master rows * project_master rows) = 50.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator