Consider two relational tables:

Employee:  

Emp_id

Emp_name

Emp_sex

Emp_designation

1

Mahesh

Male

SD

2

Rahul

Male

CD

4

Ravi

Male

TM

5

Swati

Female

TL

Company : 

Emp_id

Company_name

Company_address

1

Nokia

Gwalior

1

Samsung

Chandigarh

2

HP

Panchkula

3

Apple

Morena

Where Emp_id in company relation references to Emp_id in Employee relation.

How many numbers of rows are possible in output of the below query? 

(SELECT *FROM Employee E, Company C where E.Emp_id < > C.Emp_id and E.Emp_id % C.Emp_id) intersect (SELECT *FROM Employee E Left outer join Company C on E.Emp_id % C.Emp_id OR E.Emp_name = ‘Mahesh’ OR C. Company_name = ‘HP’ or ‘Apple’)

Enter numerical value using the virtual keypad. Round off where necessary.

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation