在表emp里，统计员工的年薪并生成别名AnnualSalary？（）

A.selectt1.emp_name,t2.salfromempt1,salt2wheret1.emp_id=t2.emp_id

B.selectt1.emp_name,t2.salfromempt1leftjoinsalt2ont1.emp_id=t2.emp_id

C.selectt1.emp_name,t2.salfromempt1whereemp_idin(selectt2.emp_idfromsalt2)

D.selectt1.emp_name,t2.salfromempt1leftjoinsalt2wheret1.emp_id=t2.emp_id

A.select ename， sal*12 ’Annual Salary' from emp

B.select ename， sal*12 “Annual Salary” from emp

C.select ename， sal*12 as Annual Salary from emp

D.select ename， sal*12 as initcap(“ANNUAL SALARY”)from emp;

A、Select Name,Job,(Sal*12 +100+200) As Income From Emp

B、Select Name,Job,(Sal+100+200)*12 As Income From Emp

C、Select Name,Job,(Sal+100+200)/12 As Income From Emp

D、Select Name,Job,(Sal+300)/12 As Income From Emp

A.SELECT ename， sal FROM EMP

B.SELECT ename，sal， sal+100 FROM emp

C.SELECT ename，sal，12*sal+100 FROM emp

D.SELECT ename，sal，12*（sal+100）FROM EMP

A.UPDATE emp SET salary+=300 where eNum='01099';

B.UPDATE emp SET salary=salary+300 where eNum='01099';

C.ALTER TABLE emp SET salary=salary+300 where eNum='01099';

D.ALTER TABLE emp SET salary+=300 where eNum='01099';

A.UPDATE emp SET salary+=300 where eNum='01099';

B.UPDATE emp SET salary=salary+300 where eNum='01099';

C.ALTER TABLE emp SET salary=salary+300 where eNum='01099';

D.ALTER TABLE emp SET salary+=300 where eNum='01099';

A.select ename from emp where sysdate-hiredate>5

B.select ename from emp where hiredate-sysdate>5

C.select ename from emp where (sysdate-hiredate)/365>5

D.select ename from emp where(sysdate-hiredate)*365>5

A.type array arr_type[emp.ename%type] index by binary_integer;

B.type table arr_type[emp.ename%type] index by binary_integer;

C.type arr_type is table of emp.ename%type index by binary_integer;

D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;