单选题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 EN

题目

单选题

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?（）

SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

参考答案和解析

正确答案： C

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

单选题The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）A randomlyB ascending by dateC descending by dateD ascending alphabeticallyE descending alphabetically

点击查看答案
相关问题 2：

单选题The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）A Column definitions cannot be altered to add DEFAULT values.B A change to the DEFAULT value affects only subsequent insertions to the table.C Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.D All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

点击查看答案
相关问题 3：

单选题The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）A Column definitions cannot be altered to add DEFAULT values.B A change to the DEFAULT value affects only subsequent insertions to the table.C Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.D All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

点击查看答案
相关问题 4：

单选题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;

点击查看答案
相关问题 5：

单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）A The SQL statement displays the desired results.B The column in the WHERE clause should be changed to display the desired results.C The operator in the WHERE clause should be changed to display the desired results.D The WHERE clause should be changed to use an outer join to display the desired results.

点击查看答案
相关问题 6：

单选题The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）A The results are not sorted.B The results are sorted numerically.C The results are sorted alphabetically.D The results are sorted numerically and then alphabetically.

点击查看答案
相关问题 7：

单选题The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）A Column definitions cannot be altered to add DEFAULT values.B A change to the DEFAULT value affects only subsequent insertions to the table.C Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

点击查看答案

1Z0-007

单选题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 EN

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容