如果对关系emp（eno，ename，salary）成功执行下面的SQL语句：CREATECLUSTERINDEXname_indexONemp（salary），其结果是（）..

第1题

[单选题] 如果对关系emp（eno，ename，salary）成功执行下面的SQL语句： CREATE CLUSTER INDEX name_index ON emp（salary）对此结果的正确描述是（）。

A、在emp表上按salary升序创建了一个唯一索引  B、在emp表上按salary降序创建了一个唯一索引  C、在emp表上按salary升序创建了一个聚簇索引  D、在emp表上按salary降序创建了一个聚簇索引  

点击查看答案

第2题

[单选题] 查询出所有名字以’S’开始的员工（）

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_';  

点击查看答案

第3题

[单选题] 在Oracle中，下面哪条语句当COMM字段为空时显示0，不为空时显示COMM的值（）。

A、select ename,nvl（comm.,0）from emp  B、select ename,null（comm.,0）from emp  C、SELECT ename,NULLIF（comm,0）FROM emp  D、SELECT ename,DECODE（comm.,NULL,0）FROM emp  

点击查看答案

第4题

[] 在PL/SQL中定义一个可以存放雇员表（EMP）的员工名称（ENAME）的PL/SQL表类型，应该（）

A、A.type array arr_type[emp.ename%type] index by binary_integer;  B、B.type table arr_type[emp.ename%type] index by binary_integer;  C、C.type arr_type is table of emp.ename%type index by binary_integer;  D、D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;  

点击查看答案

第5题

[单选题] The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;  B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;  C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;  D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;  

点击查看答案

第6题

[单选题] The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;  B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;  C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;  D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;  

点击查看答案

第7题

[单选题] The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;  B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;  C、SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;  D、SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;  

点击查看答案

第8题

[单选题] Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);  B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));  C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));  D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));  

点击查看答案

第9题

[单选题] Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);  B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));  C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));  D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));  

点击查看答案

如果对关系emp（eno，ename，salary）成功执行下面的SQL语句：CREATECLUSTERINDEXname_indexONemp（salary），其结果是（）

请使用微信扫码支付