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...
The purpose of the Toggle Filter button alternates between applying and removing a filter.
a. true b. false
Computer Science & Information Technology
If an accountant is generating employee paychecks for last week's payroll, the accountant is retrieving data from the company's ________ database
A) data warehouse B) payroll database C) transactional D) operational
Computer Science & Information Technology