單項(xiàng)選擇題

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;

你可能感興趣的試題

多項(xiàng)選擇題

Which two statements complete a transaction? （）

A.DELETE employees;
B.DESCRIBE employees;
C.ROLLBACK TO SAVEPOINT C;
D.GRANT SELECT ON employees TO SCOTT;
E.ALTER TABLE employees SET UNUSED COLUMN sal;
F.SELECT MAX(sal) FROM employees WHERE department_id = 20;

多項(xiàng)選擇題

Which two statements are true about constraints? （）

A.The UNIQUE constraint does not permit a null value for the column.
B.A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
C.The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
D.The NOT NULL constraint ensures that null values are not permitted for the column.