39在Oracle中表vendor包含以下列： Vendor_ID number primary key Name varchar30 Location_ID number Order_dt date Order_amount number82 下列对表vendor操作的语句合法的是选择2项aselect locaton_idavgorder_amountfrom vendor;b select

a)select locaton_id,avg(order_amount)from vendor; c) select sum(order_amount) from vendor;

a)open emp_cur; loop fetch emp_cur into p_emp; if emp_cur%found then dbms_output.put_line(‘Emp Name:’||p_emp); else exit end loop; close emp_cur;

c)open emp_cur; fetch emp_cur into p_emp; while emp_cur%found loop dbms_output.put_line(‘Emp Name:’||p_emp); end loop; close emp_cur;

41．C Union

42．A 触发器创建成功,该触发器将每次插入新记录的ename列变为大写