Register
Dark Mode

Databases

in Databases
110 views
0 votes
0 votes

Please explain option c.

in Databases
by
110 views

1 comment

by
S.B can have tuples with B>=6. Now, when you filter our R.B<6 tuples from R, you eliminate R.B>=6 tuples from R.

Now if you do Right Outer Join for S.B>=6 you will get extra tuples.
1
1

Please log in or register to answer this question.

← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
Overflow04 asked in Databases Nov 29, 2022
111 views
Databases
In Query1, how mid is projected from did.?????????/
Overflow04 asked in Databases Nov 29, 2022
by Overflow04
111 views
2 votes
2 votes
1 answer
4
AmitPatil asked in Databases Feb 1, 2017
644 views
Ace Test Series: Databases - Er Diagram
AmitPatil asked in Databases Feb 1, 2017
by AmitPatil
644 views

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

Subjects

Developed by Chun