单选题查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）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表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）
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';

相似考题

1.以下语句不正确的是( )A.select * from emp;B.select ename,hiredate,sal from emp;C.select * from emp order deptno;D.select * from where deptno=1 and sal

2.列出EMP表中,从事每个工种(JOB)的员工人数()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;

3.限制从EMP表中只选出前5条记录的查语句为()。A.SELECT TOP 5 * FROM EMPB.SELECT DISTINCT 5 * FROM EMPC.SELECT * FROM EMP WHERE ROWNUM<6D.SELECT * FROM EMP WHERE ROWNUM=5

4.The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement 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;

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）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”相关问题

  • 第1题：

    找出emp表中的dept表没有的dept_no 使用Exists方式实现 即改写select * from emp a where a.dept_no not in (select b.dept_no from dept b)


    正确答案：SELECT *   FROM EMP A  WHERE NOT EXISTS  
     (SELECT 1 FROM DEPT B WHERE A.DEPT_NO = B. DEPT_NO) 

  • 第2题：

    查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）

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

    正确答案:D

  • 第3题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float），Comm（奖金，Float，可为空）。查询出雇员编号不为791，792，793的雇员信息应该是用哪些数据查询？（）

    • A、Select * From Emp Where EmpNO Not In('791','792','793') 
    • B、Select * From Emp Where EmpNO !='791' AND EmpNO!='792' And EmpNO='793' 
    • C、Select * From Emp Where EmpNO <>'791' AND EmpNO<>792' And EmpNO=<>793' 
    • D、Select * From Emp Where EmpNO =!'791' AND EmpNO =!'792' And EmpNO =!'793'

    正确答案:A,B,C

  • 第4题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。查询出职位不为“办事员”的雇员信息是（）

    • A、Select *From Emp Where Job>="办事员"
    • B、Select* From Emp Where Job==’办事员’
    • C、Select* From Emp Where Job<>’办事员’
    • D、Select* From Emp Where Job!=’办事员’

    正确答案:C,D

  • 第5题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float），Comm（奖金，Float，可为空）。查询出雇员编号为791，792，793的雇员信息是（）

    • A、Select * From Emp Where EmpNO  In('791','792','793') 
    • B、Select * From Emp Where EmpNO ='791' Or EmpNO='792' OR EmpNO='793' 
    • C、Select * From Emp Where EmpNO >='791' And EmpNO<='793' 
    • D、Select * From Emp Where EmpNO >'791' And EmpNO<'793'

    正确答案:A,B,C

  • 第6题：

    You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）

    • A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
    • B、SELECT last_name FROM EMP WHERE last name ='*A%'
    • C、SELECT last_name FROM EMP WHERE last name ='_A%';
    • D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'

    正确答案:A

  • 第7题：

    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;

    正确答案:C

  • 第8题：

    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）

    • A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
    • B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
    • C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
    • D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
    • E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

    正确答案:C

  • 第9题：

    列出EMP表中，从事每个工种（JOB）的员工人数（）

    • 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;

    正确答案:D

  • 第10题：

    单选题
    查询出EMP表中COMM字段为空的记录（）
    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
    解析： 暂无解析

  • 第11题：

    单选题
    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（）
    A

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);

    B

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH READ ONLY;

    C

    CREATE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   WITH CHECK OPTION;

    D

    CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20);

    E

    CREATE FORCE VIEW emp_vu AS   SELECT *   FROM employees   WHERE department_id IN (10,20)   NO UPDATE;


    正确答案： D
    解析： 暂无解析

  • 第12题：

    ( 难度：中等)以下哪些Mysql语句是正确的？
    A.select * from emp; 
    B.select ename,hiredate,sal from emp;  
    C.select * from emp order deptno;  
    D.select * from where deptno=1 and sal＜300;
    E.select * from where deptno=1 group by sal;

    答案:ABD

  • 第13题：

    关于HQL的聚合函数使用，说法正确的是（）。

    • A、select count(*) from Dept d用于统计部门个数
    • B、select sum(e.salary) from Emp e用于汇总员工工资总额
    • C、select max(e.hiredate) from Emp e用于找到最新入职的员工的入职时间
    • D、select min(e.hiredate) from Emp e用于找到最早入职的员工的入职时间

    正确答案:A,B,C,D

  • 第14题：

    语句SELECT * FROM dept WHERE NOT EXISTS （SELECT * FROM emp WHERE deptno=dept.deptno）执行后的结果为（）

    • A、只显示存在于EMP表中的部门全部信息
    • B、只显示不存在于EMP表中的部门全部信息
    • C、未返回任何数据
    • D、显示DEPT表中的全部信息

    正确答案:B

  • 第15题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）

    • A、Select * From Emp 
    • B、Select * From Emp Where EmpNO Like '%%' 
    • C、Select * From Emp Where Name = '%%' 
    • D、Select * From Emp Where Name Like '%%'

    正确答案:A,B,D

  • 第16题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。查询出受雇于1981年的雇员信息是（）

    • A、elect * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31'  
    • B、Select * From Emp Where Between In '1981-1-1' And <'1981-12-31'
    • C、Select * From Emp Where Between In '1981-12-31' And <'1981-1-1'  
    • D、Select * From Emp Where HirDate>='1981-1-1' NOT HirDate <='1981-12-31'

    正确答案:A,B,C

  • 第17题：

    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

    • A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
    • B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
    • C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
    • D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
    • E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

    正确答案:C

  • 第18题：

    查询出所有名字以’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_';

    正确答案:C

  • 第19题：

    限制从EMP表中只选出前5条记录的查语句为（）。

    • A、SELECT TOP 5 * FROM EMP
    • B、SELECT DISTINCT 5 * FROM EMP
    • C、SELECT * FROM EMP WHERE ROWNUM<6
    • D、SELECT * FROM EMP WHERE ROWNUM=5

    正确答案:C

  • 第20题：

    Which SQL statement returns a numeric value?（）

    • A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
    • B、SELECT ROUND(hire_date) FROM EMP;
    • C、SELECT sysdate-hire_date FROM EMP;
    • D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;

    正确答案:C

  • 第21题：

    多选题
    关于HQL的聚合函数使用，说法正确的是（）。
    A

    select count(*) from Dept d用于统计部门个数

    B

    select sum(e.salary) from Emp e用于汇总员工工资总额

    C

    select max(e.hiredate) from Emp e用于找到最新入职的员工的入职时间

    D

    select min(e.hiredate) from Emp e用于找到最早入职的员工的入职时间


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    单选题
    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）
    A

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);

    B

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;

    C

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;

    D

    CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);

    E

    CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
    A

    Exhibit A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


    正确答案： C
    解析： 暂无解析

相关内容