engineering recuitment UKPSC Polytechnic Lecturer Mock Test 2024 DBMS Query Language Relational Algebra
Assume the given tables Dance and Music.
Dance
|
SNo |
Name |
Class |
|
1 |
Aastha |
7A |
|
2 |
Mahira |
6A |
|
3 |
Mohit |
7B |
|
4 |
Sanjay |
7A |
Music
|
SNo |
Name |
Class |
|
1 |
Mehek |
8A |
|
2 |
Mahira |
6A |
|
3 |
Lavanya |
7A |
|
4 |
Sanjay |
7A |
|
5 |
Abhay |
8A |
Which operation should be applied to the table to get the following output?
|
SNo |
Name |
Class |
|
1 |
Aastha |
7A |
|
2 |
Mahira |
6A |
|
3 |
Mohit |
7B |
|
4 |
Sanjay |
7A |
|
1 |
Mehek |
8A |
|
3 |
Lavanya |
7A |
|
5 |
Abhay |
8A |
1
∪
2
∩
3
-
4
X