OOPS
October 17, 2023GATE 2017 [Set-2]
October 17, 2023Database-Management-System
| Question 252 |
Database table by name overtime_allowance is given below
What is the output of the following SQL query?
select count(*) from ((select Employee, Department from Overtime_allowance) as S
natural join (select Department, OT_allowance from Overtime_allowance) as T);
What is the output of the following SQL query?
select count(*) from ((select Employee, Department from Overtime_allowance) as S
natural join (select Department, OT_allowance from Overtime_allowance) as T);
| 16 | |
| 4 | |
| 8 | |
| None of the above |
Question 252 Explanation:
Common attributes in both the table column are the department. So, we apply natural join, it will give the output as common tuples in both the table S and R.
Correct Answer: B
Question 252 Explanation:
Common attributes in both the table column are the department. So, we apply natural join, it will give the output as common tuples in both the table S and R.