According to the salesman, they raised the price because has been skyrocketing

A.SAL≤10－2

B.SAL≤10－3

C.SAL≤10－4

D.SAL≤10－5

E.SAL≤10－6

A.SAL≤10－2

B.SAL≤10－3

C.SAL≤10－4

D.SAL≤10－5

E.SAL≤10－6

A.select sal,decode(sal＞3000,‘A‘,sal＞2000,‘B‘,‘C‘) grade from emp;

B.select sal,decode(sal,3000,‘A‘,2000,‘B‘,‘C‘) grade from emp;

C.select sal,(case when sal＞3000 then ‘A‘ when sal＞2000 then ‘B‘ else ‘C‘ end) grade from emp;

D.select sal,(if sal＞3000 then ‘A‘ elsif sal＞2000 then ‘B‘ else ‘C‘ end if) grade from emp;

A.SELECTmax（sal）,deptnoFROMEMPORDERBYsal

B.SELECTmax（sal）,deptnoFROMEMPORDERBYdeptno

C.SELECTmax（sal）,deptnoFROMEMPGROUPBYdeptno

D.SELECTmax（sal）,deptnoFROMEMPGROUPBYsal

A.GRANT CHANGE ON SCOTT.EMP TO SA

B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA

C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA

D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

A.selectjob,min（sal）fromempgroupbyjob

B.selectjob,min（sal）fromempwheredept_id=1groupbyjob

C.selectjob,max（sal）fromempwheredept_id=1groupbyjob

D.selectjob,min（sal）fromempwheredept_id=1

以下语句错误的是()

A.select sal+1 from emp;

B.select sal*10,sal*deptno from emp;

C.不能使用运算符号

D.select sal*10,deptno*10 from emp;

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.SELECTename,sal*12,AnnualSalaryFROMemp

B.SELECTename,sal*12"AnnualSalary"FROMemp

C.SELECTename,sal*12ASAnnualSalaryFROMemp

D.SELECTename,sql*12ASINICTAP("AnnualSalary")FROMemp