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;
A.Windows NT
B.Windows 2000
C.Windows 98
D.SCO UNIX
E.Redhat Linux
最新试题
当CKPT进程工作时,会对哪类文件执行I/O操作()
对于ORACLE PL/SQL标识符(Identifier)的有效长度是()
在PL/SQL环境中,以下说法正确的是()
以下关于PL/SQL块的说法正确的是()
emp表是雇员信息表,sal字段存放是的雇员的月薪,以下哪个变量可以存放sal类型的值()
假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库()
表空间默认的PCTINCREASE参数值为下列哪一个()
下面哪一个不是数据库物理存储结构中的对象()
如何强制执行日志切换()
以下ORACLE认证的级别由低到高排列正确的是()