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
问题
Which SQL statement returns a numeric
参考解析：
分类：1Z0-007题库
相关推荐
-
1、Which SQL statement defines the FOREIG
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）A CREATE TABLE EMP (empno NUMBER(4), ename V...
-
2、Which of the following SQL statements
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary...
-
3、Which two statements regarding a SQL p
Which two statements regarding a SQL profile are true?（）A It is built by Automatic Tuning Optimizer.B It cannot be stored persistently in the...
-
4、Which SQL statement displays the date
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）A SELECT TO_CHAR(...
-
5、Which SQL statement defines a FOREIGN
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCHAR...
-
6、Which SQL statement accepts user input
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A SELECT &1, "&2" FROM &3 WH...