Customer
|
cname |
st |
city |
Account
|
acno |
cname |
bal |
bname |
Loan
|
lno |
cname |
amt |
bname |
Query (i) : Select cname from customer
Where cname in (select cname From Account
where cname = any (select cname From loan)) ;
Query (ii) : (π cname ((customer ⋈ Account)⋈ Loan)
Query (iii) : (πcname (customer ⋈ (Account ⋈ loan)))
Query (iv): Select cname from customer C
where exists ((select cname from Loan) Intersect (select cname from Account where cname = C.cname));
Which of the following is false statement?
1
Query (i) & query (iv) gives the same result
2
Query (ii) & query (iii) gives the same result
3
Query (i) and Query (iii) gives the different result
4
Query (ii) & query (iv) gives the same result
5
Question Not Attempted