Assuming the select statement below is a proper query, which is true regarding the following statement?
create view example as
select vendor_name, sum(invoice_total) as "invoice sum"
from vendors join invoices on vendors. vendor_id = invoices. vendor_id
group by vendor_name order by vendor_name; (points : 4)
(a) it will fail because the group by clause is not allowed in a view.
(b) it will fail because sum function is not allowed in a view.
(c) it will fail because order by clause is not allowed in a view.
(d) it will succeed.

Asingle-geared blanking press has a stroke of 200 mm and a rated capacity of 320 kn. a cam driven ram is assumed to be capable of delivering the full press load at constant force during the last 15 percent of a constant-velocity stroke. the camshaft has an average speed of 90 rev/min and is geared to the flywheel shaft at a 6: 1 ratio. the total work done is to include an allowance of 16 percent for friction a) estimate the maximum energy fluctuation b) find the rim weight for an effective diameter of 1.2 m and a coefficient of speed fluctuation of 0.10