50)a(a. All employees have a manager.)
51)b(b. A non-pair wise comparison produces a cross product.)
52)b. A WHERE clause cannot be used to restrict groups.
53)c. Produces one result from many rows per group.
54)d. No change is needed.
55)d. The statement will not execute.
56)b. UPDATE
57)b. Allows you to choose columns.
58)b. 2
59)b. SELECT hire_date
FROM worker
ORDER BY hire_date;
60)c. division_table(13).loc:=‘Boston’;
52)b. A WHERE clause cannot be used to restrict groups.
53)c. Produces one result from many rows per group.
54)d. No change is needed.
55)d. The statement will not execute.
56)b. UPDATE
57)b. Allows you to choose columns.
58)b. 2
59)b. SELECT hire_date
FROM worker
ORDER BY hire_date;
60)c. division_table(13).loc:=‘Boston’;
