根据投资对策的不同，证券投资基金可分为（）等。

A．A.insert into emp(ename,hiredate,sal) values (value1,value2,value3);

B．B.insert into emp (ename,sal)values(value1,value2,value3);

C．C.insert into emp (ename)values(value1,value2,value3);

D．D.insert into emp (ename,hiredate,sal)values(value1,value2);

以下语句不正确的是()

A.select * from emp;

B.select ename,hiredate,sal from emp;

C.select * from emp order deptno;

D.select * from where deptno=1 and sal<300;

A．select ename,hiredate from emp where ename = FORD；

B．select ename,hiredate from emp where hiredate > （select hiredate from emp where ename = FORD）;

C．select ename,hiredate from emp where hiredate > min（hiredate） and ename = FORD;

D．select ename,hiredate from emp where hiredate in （select hiredate from emp where ename = FORD）

A．select * from emp;

B．select ename,hiredate,sal from emp;

C．select * from emp order deptno;

D．select * from where deptno=1 and sal＜300;

E．select * from where deptno=1 group by sal;

A．A.select * from emp;

B．B.select ename,hiredate,sal from emp;

C．C.select * from emp order deptno;

D．D.select * from where deptno=1 and sal<300;

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

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

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

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

A．select ename，sal，comm from emp where sal>=2500 or sal<=4000;

B．select ename，sal，comm from emp where sal>=2500 and salz<=4000;

C．select ename，sal，comm from emp where sal between 2500 or 4000;

D．select ename，sal，comm from emp where sal between 2500 and 4000;

the monthly salary of the employee. Which change must be made to the abovesyntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"？ （）

A. No change is required to achieve the desired results.

B. SELECT ename, sal, 12* (sal+100) FROM emp;

C. SELECT ename, sal, (12* sal)+100 FROM emp;

D. SELECT ename, sal +100,*12 FROM emp;

the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"？（）

A. No change is required to achieve the desired results.

B. SELECT ename, sal, 12* (sal+100) FROM emp;

C. SELECT ename, sal, (12* sal)+100 FROM emp;

D. SELECT ename, sal +100,*12 FROM emp;