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.
Subscribe
Login
0 Comments