Consider the two tables T1 and T2 shown in Figure 6.15. Show the results of the following operations:

What will be an ideal response?


(a)
P Q R A B C
10 a 5 10 b 6
10 a 5 10 b 5
25 a 6 25 c 3
(b)
P Q R A B C
15 b 8 10 b 6
15 b 8 10 b 5
(c)
P Q R A B C
10 a 5 10 b 6
10 a 5 10 b 5
15 b 8 null null null
25 a 6 25 c 3
(d)
P Q R A B C
15 b 8 10 b 6
null null null 25 c 3
15 b 8 10 b 5
(e)
P Q R
10a 5
15 b 8
25 a 6
10b 6
25 c 3
10b 5
(f)
P Q R A B C
10 a 5 10 b 5

Computer Science & Information Technology

You might also like to view...

XML documents __________.

a) are highly portable b) are not portable c) are portable depending on how the document is written d) are a burden to use

Computer Science & Information Technology

What is the granularity of the fact table shown in the property sales DM?

What will be an ideal response?

Computer Science & Information Technology

What is the best way to describe this function prototype?

``` bool Func(int a, int b, int &rC);``` A. It is indescribable. B. The function returns a true/false and has 3 integer inputs. C. The function has two integere inputs and “returns” an integer and a bool. D. This function prototype will not compile.

Computer Science & Information Technology

The entire chart and all of its elements comprise the ________

Fill in the blank(s) with correct word

Computer Science & Information Technology