252 views
2 votes
2 votes

condition for all , any & some in the database .

Q1) if A>ALL(B)

   Where

Case 1) A={2}, B={ }

Case 2) A={2}, B={ 1,2,3}

Case 1) A={2}, B={ NULL,1,2}

Q2) if A>ANY(B)

   Where

Case 1) A={2}, B={ }

Case 2) A={2}, B={ 1,2,3}

Case 1) A={2}, B={ NULL,1,2}

Q1) if A>SOME(B)

   Where

Case 1) A={2}, B={ }

Case 2) A={2}, B={ 1,2,3}

Case 1) A={2}, B={ NULL,1,2}

1 Answer

1 votes
1 votes

Q1) if A>ALL(B)

   Where

Case 1) A={2}, B={ } :- T

Case 2) A={2}, B={ 1,2,3}:- F

Case 1) A={2}, B={ NULL,1,2}:- F

Q2) if A>ANY(B)

   Where

Case 1) A={2}, B={ }:- F

Case 2) A={2}, B={ 1,2,3}:-T

Case 1) A={2}, B={ NULL,1,2}:- T

Q1) if A>SOME(B)

   Where

Case 1) A={2}, B={ }:- F

Case 2) A={2}, B={ 1,2,3}:- T

Case 1) A={2}, B={ NULL,1,2}:- T

Related questions

1 votes
1 votes
0 answers
1
JAINchiNMay asked Dec 1, 2022
437 views
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
0 votes
0 votes
1 answer
3
abhinowKatore asked Sep 8, 2022
261 views
If a schedule is not conflict-serializable. Is it serializable?
1 votes
1 votes
1 answer
4
Manisha Jaishwal asked Aug 10, 2022
346 views
S:- R1(x) R1(y) W1(x) R2(z) R2(y) W3(y) R2(y)Schedule is view Serializable or not ?