Consider the following relational schema:
department(dept_id, building_id, manager, building)
The following SQL query will return
(select dept_id from department where manager = 'Raj')
union all
(select dept_id from department where manager = 'Rahul')
1
The query will return all the dept_id whose manager is Raj or Rahul and will retain duplicates.
2
The query will return all the dept_id whose manager is Raj or Rahul and will not retain duplicates.
3
The query will return all the dept_id whose manager is Raj and Rahul and will retain duplicates.
4
The query will return all the dept_id whose manager is Raj and Rahul and will not retain duplicates.
5
Question Not Attempted