A.1
B.2
C.3
D.4
E.由初始参数指定
您可能感兴趣的试卷
你可能感兴趣的试题
A.select last_date(sysdate) from dual;
B.select finally_day(sysdate) from dual;
C.select last_day(sysdate) from dual;
D.select tail_day(sysdate) from dual;
A.select to_char(sysdate,'D') from dual;
B.select to_char(sysdate,'W') from dual;
C.select to_char(sysdate,'D')-1 from dual;
D.select to_char(sysdate-1,'D') from dual;
E.select to_char(sysdate-1,'W') from dual;
A.select * from emp where hiredate>='19820101';
B.select * from emp where hiredate>=to_char('19820101','YYYYMMDD');
C.select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';
D.select * from emp where to_char(hiredate,'YYYYMMDD')>='19820101';
A.select * from emp where comm='';
B.select * from emp where comm=null;
C.select * from emp where nvl(comm)=0;
D.select * from emp where comm is null;
E.select * from emp where nvl(comm,0)=0;
A.select * from emp wher sal in (2000,3000);
B.select * from emp wher sal like (2000,3000);
C.select * from emp wher sal = (2000,3000);
D.select * from emp wher sal between 2000 and 3000;
A.select * from emp where ename in 'S%';
B.select * from emp where ename='S%';
C.select * from emp where ename like 'S%';
D.select * from emp where ename like 'S_';
A.select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
B.select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
C.select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
D.select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
A.A UNION B
B.A UNION ALL B
C.A INTERSECT B
D.A MIUS B
A.A MIUS B
B.B MINUS A
C.A INTERSECT B
D.B INTERSECT A
A.select job from emp;
B.select job,count(*) from emp;
C.select distinct job,count(*) from emp;
D.select job,count(*) from emp group by job;
E.select job,sum(empno) from emp group by job;
最新试题
对于以下SQL语句说法正确的是()SELECT ename FROM empWHERE sal IN (SELECT MAX(sal)FROM emp GROUP BY deptno);
数据字典信息被存放在哪类文件中()
在PL/SQL环境中,以下说法正确的是()
以下关于包(Package)的说法,正确的是()
对于oracle数据库,设计用户表时,家庭住址字段最好采用下面的哪个数据类型进行存储()
以下哪类表空间中不能建立数据对象(表,索引)()
以下对于SQL比较运算符ANY和ALL的说法正确的是()
假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库()
ORACLE数据库启动后,有哪五个必要的后台进程(mandatory background processes)()
在PL/SQL中用以下哪个运算符或函数,可以将两个字符串连接起来()