Oracle
- 你要操纵Oracle数据,下列哪个不是SQL命令?
A.select * from dual; B.set define
C.update emp set ename = 6543 where ename = ‘SMITHERS’;
D.create table employees(empid varchar2(10) primary key);
- 要从ORDERS表中取得数据,其中包括三个列CUSTOMER、ORDER_DATE与ORDER_AMT。可以用下列 哪个where子句查询ORDERS表,取得客户LESLIE超过2700的订单?
A.where customer = ‘LESLIE’;
B.where customer = ‘LESLIE’ and order_amt < 2700;
C.where customer = ‘LESLIE’ or order_amt > 2700;
D.where customer = ‘LESLIE’ and order_amt > 2700;
- 下列那些是Oracle的伪列() (选择两项)
A.ROWID B.ROW_NUMBER() C.ROWNUM D.COLUMN
- 在建表时如果希望某列的值,在一定的范围内,应建什么样的约束?( )
A.primary key B.unique C.check D.not null
- 如果要显示last_name中第二个字符为“A”的员工的姓名,下列那条SQL语句是正确的?
- Select last_name from emp where last_name like ‘_A%’;
- Select last_name from emp where last_name = ‘*A%’;
- Select last_name from emp where last_name = ‘_A%’;
- Select last_name from emp where last_name like ‘*A%’;
- 那一个查询语句能够提取当前的系统时间并且显示成“2010”的格式?
- Select to_char(sysdate, ’yyyy’) from dual;
- Select to_char(substr(sysdate,8,2), ’year’) from dual;
- Select to_date(sysdate, ’yyyy’) from dual;
- Select decode(substr(sysdate,8), ’YYYY’) from dual;
- 有数据”test”分别存放到char(10)和varchar2(10)类型的字段中,其实际存储长度为
10 10
4 4
10 4
4 10
- 在Oracle中,下面用于限制分组函数的返回值的子句是()。
A.WHERE B.HAVING C.ORDER BY D.无法限定分组函数的返回值
- 在Oracle中,下面哪条语句当COMM字段为空时显示0,不为空时显示COMM的值()。
SELECT ename, NVL(comm, 0) FROM emp;
SELECT ename, NULL(comm, 0) FROM emp;
SELECT ename, NULLIF(comm, 0) FROM emp;
SELECT ename, DECODE(comm, NULL, 0) FROM emp;
- 在Oracle中,有一个教师表teacher的结构如下:
ID NUMBER(5)
NAME VARCHAR2(25)
EMAIL VARCHAR2(50)
下面哪个语句显示没有Email地址的教师姓名()。
SELECT name FROM teacher WHERE email = NULL;
SELECT name FROM teacher WHERE email <> NULL;
SELECT name FROM teacher WHERE email IS NULL;
SELECT name FROM teacher WHERE email IS NOT NULL;
- SALES表中的PROFITS列声明为NUMBER(10, 2)。下列哪个值无法在这个列中存储?
A.5392845.324 B.871039453.1 C.75439289.34 D.60079829.25
- 对数据库运行下列哪个group by查询时会从Oracle产生错误?
- select deptno, job, sum(sal) from emp group by job, deptno;
- select sum(sal), deptno, job from emp group by job, deptno;
- select deptno, job, sum(sal) from emp;
- select deptno, sum(sal), job from emp group by job, deptno;